mysql表字段操作


添加字段:

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

普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress