select table_name,table_rows from information_schema.tables where table_schema='数据库名' order by table_rows desc;
查询mysql某个库中 各个表的行数
最新推荐文章于 2024-07-09 22:26:42 发布
select table_name,table_rows from information_schema.tables where table_schema='数据库名' order by table_rows desc;