1.给表添加字段 alter table table_name add field_name field_type;
eg:alter table user add username varchar(32) not null;
2.删除表中的字段 alter table table_name drop field_name;
eg:alter table user drop username;
3.修改表中的字段名,字段属性 alter table table_name change old_field_name new_field_name field_type
eg:alter table user change username username1 varchar(64) default 'hh';
or:alter table user change username username varchar(64) default 'hh';
4.添加表中主键 alter table table_name add primary key(field_name);
eg:alter table user add primary key(id);
5.许多时候希望table中数据的id不要从1开始,像qq, id从10000开始
eg:alter table users AUTO_INCREMENT=10000;
6.修改字段为自增 alter table table_name modify field_name filed_type auto_increment;
eg: alter table user modify id smallint(5) unsigned auto_increment;
对于mysql基本操作可参考:MySQL命令;