#数据库中所有表的信息 SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘数据库名‘ #数据库中每个表的数据量 SELECT table_name,table_rows FROM information_schema.tables WHERE TABLE_SCHEMA = ‘数据库名‘ ORDER BY table_rows DESC;
原文：https://www.cnblogs.com/shenyixin/p/14789074.html