select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = ‘数据库名称’ order by table_rows desc;
MySQL查询数据库中所有数据表的数据条数
最新推荐文章于 2024-07-09 10:20:39 发布
select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = ‘数据库名称’ order by table_rows desc;