mysql查询各表数据量

select TABLE_NAME, 
concat(truncate(data_length/1024/1024,2),' MB') as data_size,
table_rows
from information_schema.tables where TABLE_SCHEMA = 'bim-mes-chum-demo2' 
order by table_rows desc;