SELECT table_schema AS '数据库', table_name AS '表名', table_rows AS '记录数', TRUNCATE ( data_length / 1024 / 1024, 2 ) AS '数据容量(MB)', TRUNCATE ( index_length / 1024 / 1024, 2 ) AS '索引容量(MB)' FROM information_schema.tables WHERE table_schema = '数据库名称' ORDER BY table_rows DESC, index_length DESC;
翻译
搜索
复制
标签:1024,TRUNCATE,容量,查询,length,MySQL,table,schema From: https://www.cnblogs.com/smartnn/p/17107747.html