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

3 votes309 views2 answers
Find the median in sql
SQL
0 vote326 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote295 views1 answer
Postgres 11 add primary key
SQL
2 votes310 views1 answer
How to create sql database
SQL
5 votes312 views1 answer
Oracle list functions
SQL
0 vote315 views1 answer
Sql server check whether column has same equal values
SQL
0 vote308 views1 answer
Java check if something is in mysql table
SQL
0 vote293 views2 answers
How to find max and min salary in sql
SQL
0 vote329 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
3 votes304 views2 answers
How to start postgresql on windows
SQL