SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), \'MB\') as data FROM information_schema.tables WHERE TABLE_SCHEMA=\'test\' ORDER BY DATA_LENGTH+INDEX_LENGTH desc;

结果展示：

 

版权声明：本文为yangyuke1994原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/yangyuke1994/p/10873009.html