/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

1 vote209 views1 answer
Search for tables with name postgresql
SQL
2 votes225 views1 answer
How to get weekday from old date in sql
SQL
0 vote221 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote206 views1 answer
Oracle create package body
SQL
0 vote207 views1 answer
Google sheets filter rows above current cell
SQL
3 votes209 views3 answers
How to set up an auto incrementing id db browser
SQL
3 votes226 views1 answer
Stpop start psql server
SQL
1 vote218 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote213 views1 answer
Postgres check blocking
SQL
5 votes216 views2 answers
Add column postgres with default value
SQL