MYSQL如何快速查看每个表的数据量

SELECT table_name, table_rows, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES where table_schema='test' ORDER BY table_rows desc;

效果大概就是这样：