mysql 查询记录数大于一千万的表

SELECT table_schema, table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema NOT IN ('mysql', 'performance_schema', 'information_schema', 'sys')
AND table_rows > 10000000;

posted @ 2024-08-23 10:16  仁义礼智信的  阅读(37)  评论(0)    收藏  举报