/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

2 votes357 views1 answer
Oracle block
SQL
1 vote322 views1 answer
Oracle user last connected
SQL
0 vote321 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote309 views1 answer
Recursive query herarchical data sql server
SQL
0 vote322 views1 answer
Mysql check datetime equals date
SQL
0 vote359 views2 answers
Generate sql trigger through ef migration
SQL
0 vote359 views1 answer
Add week ending date sql server
SQL
0 vote342 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote329 views1 answer
Sql cheetsheet
SQL
0 vote352 views2 answers
Mysql calcular idade
SQL