SELECT table_name, table_rows
FROM information_schema.tables
WHERE table_schema='database_name'
order by table_rows desc
统计MySQL每个表数据条数
最新推荐文章于 2024-07-04 15:22:57 发布
SELECT table_name, table_rows
FROM information_schema.tables
WHERE table_schema='database_name'
order by table_rows desc