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