mysql

查看表大小 
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data  from TABLES where  table_name='table_name';

查看建表语句
show create table table_name