How to list size of all tables of a mysql database

List the size of all tables for a mysql database:


SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) as TEST FROM information_schema.TABLES WHERE table_schema = "cellercandani" order by TEST;