ORDER BY table_rows DESC; 要统计总数据量的,加上sum函数就可以 1 2 3 4 SELECT sum(table_rows) FROM information_schema.tables WHERE TABLE_SCHEMA ='数据库名称' and table_name notin('不查询的表名称') ORDER BY table_rows DESC; 不过统计出来的可能会有误差 官网的解释:https://dev.mysql.com/...