sql常用语句

//查看table

show tables;

//查看列

show columns from XXX;

 //复合主键转为唯一主键

alter table test change id id int(11) COMMENT '自增id';
alter table test drop primary key;
alter table test add primary key(id);
alter table test change id id bigint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id';