SELECT ROUND(SUM(data_length+index_length)/1024/1024)AS total_mb,ROUND(SUM(data_length)/1024/1024)AS data_mb,ROUND(SUM(index_length)/1024/1024)AS index_mbFROM INFORMATION_SCHEMA.TABLES;
本文共 185 字,大约阅读时间需要 1 分钟。
SELECT ROUND(SUM(data_length+index_length)/1024/1024)AS total_mb,ROUND(SUM(data_length)/1024/1024)AS data_mb,ROUND(SUM(index_length)/1024/1024)AS index_mbFROM INFORMATION_SCHEMA.TABLES;
转载地址:http://ualka.baihongyu.com/