use information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = '数据库的名称' order by table_rows desc;
mysql怎么查询数据库每个表有多少条记录
最新推荐文章于 2024-07-09 10:20:39 发布
use information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = '数据库的名称' order by table_rows desc;