摘要：ALTER TABLE — 更改表属性添加字段：alter table `user_movement_log`Add column GatewayId intnot 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 0AFTER RegionIDmysql alter 阅读全文