Find the approximate file size of all tables in a MySQL database

SELECT TABLE_NAME AS "Table name",
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) as MB
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA IN ('mydatabase') 
GROUP BY TABLE_NAME
ORDER BY MB ASC;