mysql 数据库查询总条数和查看数据库中所有表的记录数

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;