修改字段属性
alter table tablename modify id int(10) unsigned auto_increment primary key not null
修改默认值
alter table tablename alter id default 0
给字段增加primary key
alter table tablename add primary key(id);
删除primary key
1、alter table tablename drop primary key;
2、drop primary key on tablename;
查看table表结构
show create table tableName;
修改table表数据引擎
alter table tableName ENGINE = MyISAM (InnoDB);
增加字段
ALTER TABLE `table` ADD `field` INT(11) UNSIGNED NOT NULL
删除字段
alert table 'table' drop 'field'