/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

0 vote185 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
23 votes188 views4 answers
How to uninstall postgresql in ubuntu
SQL
11 votes184 views2 answers
MySQL DISTINCT
SQL
12 votes182 views2 answers
Select into insert sql server
SQL
0 vote259 views3 answers
CONTACT FORM SQL
SQL
1 vote169 views1 answer
Set statistics on in ssms
SQL
0 vote211 views1 answer
Sql today at midnight
SQL
0 vote200 views1 answer
How to access to mysql without root
SQL
0 vote175 views2 answers
Csv into data postgres
SQL
2 votes183 views1 answer
Q operator in sql
SQL