1.增加列
ALTER TABLE table_name ADD field_name field_type [COMMENT '注释说明'];
2.修改列字段名称
ALTER TABLE table_name CHANGE old_field_name new_filed_name field_type;
3.修改列字段的类型信息
ALTER TABLE table_name CHANGE field_name filed_name new_field_type;
ALTER TABLE table_name MODIFY field_name field_type;
4.删除列字段
ALTER TABLE table_name DROP field_name;
5.在某个字段后增加字段:
ALTER TABLE table_name
Add column filed_name int not null default 0 AFTER `Regionid` (在哪个字段后面添加)
6.调整字段顺序
ALTER TABLE `user_movement_log` CHANGE `GatewayId` `GatewayId` int not null default 0 AFTER RegionID