Mysql查看数据库对象(SQL命令总结)

select concat(round(sum(data_length/1024/1024),2),'MB') as data_size from tables; 

select concat(round(sum(data_length/1024/1024),2),'MB') as DB_size from tables where table_schema='ehr';

select concat(round(sum(data_length/1024/1024),2),'MB') as table_size from tables where table_schema='ehr' and table_name='ehr_age';

当然了，比逐条SQL查看统计信息更厉害的就是现在的UI界面，有单，实际的东西还是SQL语句

Mysql查看数据库对象(SQL命令总结)

原文：http://blog.csdn.net/jacson_bai/article/details/44017015