select table_name as '表名', (data_length/1024/1024) as '數(shù)據(jù)容量(MB)', (index_length/1024/1024) as '索引容量(MB)', ((data_length+index_length)/1024/1024) as '數(shù)據(jù)容量+索引容量容量(MB)', table_rows as '數(shù)據(jù)行數(shù)' from information_schema.TABLES where table_schema = '表名' order by ((data_length+index_length)/1024/1024) desc