select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = '库名' order by table_rows desc这个sql就可以这样不要表明,只要数量select sum(table_rows) from information_schema.tables where TABLE_SCHEMA = '库名' order by table_rows desc