摘要：ALTER TABLE — 更改表属性添加字段：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 RegionIDmysql al 阅读全文