Get sizes of all tables in database

From: https://www.a2hosting.com/kb/developer-corner/mysql/determining-the-size-of-mysql-databases-and-tables

To determine the sizes of all of the tables in a specific database, at the 
mysql> prompt, type the following command. Replace database_name with the 
name of the database that you want to check:

SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "DATABASE_NAME"
ORDER BY (data_length + index_length) DESC;