重命名表:
ALTER TABLE t1 RENAME t2;
添加字段:(在哪个字段后面添加)
ALTER TABLE `user_movement_log` ADD COLUMN gatewayId int not null default 0 AFTER `regionid`
删除字段:
ALTER TABLE `user_movement_log` DROP COLUMN gatewayId
调整字段顺序:
ALTER TABLE `user_movement_log` CHANGE `gatewayId` `gatewayId` int not null default 0 AFTER regionid
修改原字段名称及类型:
ALTER TABLE table_name CHANGE old_field_name new_field_name field_type;
主键:
ALTER TABLE tabelname ADD new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
添加索引:
ALTER TABLE tablename ADD index emp_name (name);
加唯一限制条件的索引:
ALTER TABLE tablename ADD unique emp_name2(cardnumber);
删除某个索引:
ALTER TABLE tablename DROP index emp_name;