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 vote220 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote197 views1 answer
Search for tables with name postgresql
SQL
0 vote195 views1 answer
Pl sql search in all packages
SQL
0 vote216 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote205 views1 answer
Rails sql query converstion
SQL
2 votes204 views1 answer
Get first 2 letter in sql
SQL
1 vote210 views1 answer
Get table column names sql ssms
SQL
1 vote276 views2 answers
Coderbyte sql solutions
SQL
1 vote210 views1 answer
Sql first day quarter
SQL
4 votes194 views1 answer
Oracle table statistics last analyzed
SQL