mysql查看表结构命令，如下:
desc 表名;
show columns from 表名;
describe 表名;
show create table 表名;
use information_schema
select * from columns where table_name="表名";
顺
来源自我的博客
http://www.yingzinanfei.com/2017/04/03/chakanmysqlbiaojiegoudezhiling/
desc 表名;
show columns from 表名;
describe 表名;
show create table 表名;
use information_schema
selec
