如何查出数据库中每张表的记录数

use
information_schema;
select
table_name,table_rows
from
tables
where
TABLE_SCHEMA
=
'数据bai库名'
order
by
table_rows
desc;
查询出duzhidao的是每张表zhuan的shu行数