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_mnb
from information_schema.tables;
转载于:https://www.cnblogs.com/liang545621/p/9400966.html