select * from
(
SELECT table_schema,
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) as SizeInMb
FROM information_schema.tables
GROUP BY table_schema
) as tables
order by SizeInMb desc
select * from
(
SELECT table_schema,
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) as SizeInMb
FROM information_schema.tables
GROUP BY table_schema
) as tables
order by SizeInMb desc