查看mysql某个数据库下所有表的数据总条数 use information_schema; select sum(TABLE_ROWS) from tables where TABLE_SCHEMA = 'db_name'; 查询出来的是每张表的行数 select table_name,table_rows from tables where TABLE_SCHEMA = '数据库名' order by table_rows desc;