table_sizes.sql (183B)
SELECT table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "db_name" ORDER BY `Size in MB`;
Back (Current repo: scraps)random scraps and notes that are useful to meTo clone this repository: git clone https://git.viktor1993.net/scraps.git |
Log | Download | Files | Refs |
table_sizes.sql (183B)
SELECT table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "db_name" ORDER BY `Size in MB`;