/SQL/Find largest table in mysql database

Find largest table in mysql database

SELECT table_schema as "Database", table_name AS "Table", 
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" 
FROM information_schema.TABLES 
WHERE (data_length + index_length) > 1000000 
ORDER BY table_schema, (data_length + index_length) DESC

Similar codes

6 votes158 views5 answers
Alter table oracle
SQL
0 vote170 views1 answer
Flask sqlalchemy decimal
SQL
2 votes209 views1 answer
Sqlite3 show columns name
SQL
0 vote163 views1 answer
Oracle sql generate list of days
SQL
0 vote171 views1 answer
Mariadb mysql root access denied
SQL
-1 vote218 views1 answer
Difference berween database and data base management system
SQL
0 vote206 views1 answer
How to open mysql in docker
SQL
0 vote166 views1 answer
Exclude last comma separated string mysql
SQL
1 vote243 views1 answer
Sql server read uncommitted
SQL
0 vote198 views2 answers
Get value from a table an insert it with other values in another table sql
SQL