SELECT table_name,table_rows FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘表名’ ORDER BY table_rows DESC;
结果如下:
MySQL批量查某个库里每张表的数据量
最新推荐文章于 2023-12-11 22:44:31 发布
SELECT table_name,table_rows FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘表名’ ORDER BY table_rows DESC;
结果如下: