/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 votes341 views1 answer
Mysql see users and passwords
SQL
0 vote337 views1 answer
Sqlite update only if greater
SQL
0 vote357 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote333 views1 answer
Syntax for changing column size in mysql
SQL
3 votes345 views2 answers
How to list columns for particular tables in postgresql
SQL
4 votes394 views1 answer
Mysql store ip address
SQL
5 votes320 views3 answers
Mysql check if null or empty string
SQL
0 vote374 views2 answers
Plpgsql
SQL
5 votes390 views1 answer
Mysql count lines
SQL
0 vote347 views1 answer
Alter rename command in mysql
SQL