/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 votes198 views2 answers
Return columns from table sql
SQL
9 votes176 views3 answers
Where clause sql
SQL
0 vote218 views1 answer
Postgres rename database
SQL
5 votes166 views2 answers
To date oracle
SQL
1 vote150 views1 answer
How to test for sql injection
SQL
0 vote216 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote143 views1 answer
Nested if in mysql
SQL
0 vote153 views1 answer
Doesn't have default value mysql
SQL
0 vote179 views1 answer
Mysql value ends with
SQL
0 vote183 views1 answer
Order child below the parent in mysqli
SQL