方式一: 存储引擎为MyISAM时准确,InnoDB时为一个大概数
- 询库内所有表及行数
SELECT table_name,table_rows FROM information_schema.tables WHERE TABLE_SCHEMA = 'wltc';
- 查询库内所有表及总行数
SELECT sum(table_rows) FROM information_schema.tables WHERE TABLE_SCHEMA = 'wltc';
方式二: 利用count(*)统计
准确
- 查询库内所有表,拼接查询语句
select concat('select "',TABLE_name,'", count(*) as count from ',TABLE_SCHEMA,'.',TABLE_name,'union all') from information_schema.tables
where TABLE_SCHEMA='wltc';
- 复制上一步查询结果,加以修改(样例如下)
select sum(p1.count) from (
select "app_file_info", count(*) as 'count' from wltc.app_file_info union all
select "app_project_info", count(*) as 'count' from wltc.app_project_draft
) p1