Return size of tables in mysql

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Source: stackoverflow.com

Similar codes

2 votes206 views1 answer
Oracle to_char number format percentage
SQL
0 vote180 views1 answer
Oracle list index on table
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL
2 votes192 views1 answer
Sql like variable
SQL
0 vote249 views1 answer
Sql from null to not null
SQL
5 votes785 views1 answer
Oracle ora-00054 find
SQL
0 vote203 views1 answer
How to check replication lag in mySQL
SQL
1 vote153 views1 answer
Enable mysql slow query log
SQL
0 vote240 views1 answer
Mysql 3 months ago
SQL
0 vote209 views1 answer
Sql getdate minus 1 day without time
SQL