摘要:
总结一下对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 R 阅读全文