select TABLE_SCHEMA,TABLE_NAME,round(index_length/1024/1024,2), round(data_length/1024/1024,2),TABLE_ROWS from INFORMATION_SCHEMA.TABLES
order by DATA_LENGTH desc
你查询所有的表信息有结果吗
select TABLE_SCHEMA,TABLE_NAME,round(index_length/1024/1024,2), round(data_length/1024/1024,2),TABLE_ROWS from INFORMATION_SCHEMA.TABLES
order by DATA_LENGTH desc
你查询所有的表信息有结果吗