【zz】mysql添加字段、删除字段、调整字段顺序

转自http://www.cnblogs.com/lmjob/archive/2008/09/22/1295849.html

添加字段&＃xff1a;

alter table &＃96;user_movement_log&＃96; 
Add column GatewayId int  not null default 0 AFTER &＃96;Regionid&＃96; (在哪个字段后面添加)

 删除字段&＃xff1a;

alter table &＃96;user_movement_log&＃96; drop column Gatewayid

调整字段顺序&＃xff1a;

ALTER TABLE &＃96;user_movement_log&＃96;  CHANGE &＃96;GatewayId&＃96; &＃96;GatewayId&＃96; int not null default 0  AFTER RegionID