mysql 查詢記錄數大於一千萬的表

仁义礼智信的發表於2024-08-23

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;

相關文章