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