命令更改表结构:添加、删除、修改字段、调整字段顺序ALTER TABLE `user_movement_log` CHANGE `GatewayId` `GatewayId` int not null default 0 AFTER RegionID;//主键alter table tabelname add new_field_id int(5) unsigne