/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

8 votes120 views2 answers
Python simple connect to mysql
SQL
1 vote122 views1 answer
Age postgres
SQL
1 vote131 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote142 views10 answers
John the ripper mysql
SQL
11 votes118 views2 answers
Docker create postgres db
SQL
0 vote110 views1 answer
Psql list rules
SQL
-1 vote128 views1 answer
Module operator in oracle sql
SQL
2 votes111 views1 answer
Oracle number to percentage
SQL
0 vote120 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes117 views1 answer
How to make insert script from table in SQL server
SQL