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

0 vote223 views1 answer
Drush run sql select
SQL
13 votes232 views2 answers
Get date from now() mysql
SQL
0 vote230 views2 answers
Oracle select
SQL
0 vote213 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote232 views3 answers
Osx stop mysql service
SQL
0 vote184 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote239 views1 answer
How much space does sql server take per row
SQL
16 votes231 views2 answers
Add column if not exists mysql
SQL
20 votes243 views6 answers
Creating a table in sql
SQL
5 votes215 views6 answers
Sql add days to date
SQL