use  information_schema

select concat(round(sum(DATA_LENGTH/1024/1024),2),\’M\’),concat(round(sum(INDEX_LENGTH/1024/1024),2),\’M\’) from tables where table_schema=’mytest’ AND table_name=’test’; 

 

 

文章来源链接： http://www.cnblogs.com/diandiandidi/p/5582309.html

 

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