1.数据库查询总条数
use information_schema;
select sum(table_rows) from tables where TABLE_SCHEMA = 数据库名称;
2.mysql 查看数据库中所有表的记录数
use information_schema;
select table_name,table_rows from tables
where TABLE_SCHEMA = '数据库名称'
order by table_rows asc;
1.数据库查询总条数
use information_schema;
select sum(table_rows) from tables where TABLE_SCHEMA = 数据库名称;
2.mysql 查看数据库中所有表的记录数
use information_schema;
select table_name,table_rows from tables
where TABLE_SCHEMA = '数据库名称'
order by table_rows asc;