/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 vote149 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
2 votes103 views3 answers
How to pass password mysql command line
SQL
5 votes98 views2 answers
Oracle timestamp to date
SQL
19 votes59 views1 answer
Sqrt(-1)
SQL
0 vote99 views1 answer
Change data type in mysql
SQL
11 votes102 views1 answer
Sql query to find duplicates in column
SQL
0 vote100 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote95 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote102 views3 answers
Sql drop all tables
SQL
27 votes102 views5 answers
Add column in table
SQL