Mysql查看表的数据量

1. 查看所有表信息

SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = '库名';

2. 查看各个表数据量

SELECT table_name, table_rows FROM information_schema.TABLES WHERE TABLE_SCHEMA = '库名' ORDER BY table_rows DESC;

 

转载请注明出处：BestEternity亲笔。