/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 vote278 views1 answer
Date 3 months from today sql
SQL
19 votes252 views4 answers
Rename database in sql
SQL
0 vote280 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
3 votes261 views2 answers
Sql paging query
SQL
0 vote268 views1 answer
Sql developer search all packages for text
SQL
0 vote213 views1 answer
Kannst du deine finger trainieren
SQL
2 votes279 views1 answer
Sql server find columns list in tables
SQL
0 vote262 views1 answer
Into operator in sql
SQL
1 vote241 views1 answer
List index mysql cli
SQL
0 vote282 views1 answer
T-sql update table variale
SQL