统计数据库中表记录数

统计数据库（mysql）中各表的记录数

SELECT sum(TABLE_ROWS),TABLE_NAME
FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'evaluation'
group by TABLE_NAME;

统计某数据库（mysql）中表记录总数

SELECT sum(TABLE_ROWS)
FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'evaluation';