摘要:
1 修改表名ALTERTABLEtable_nameRENAMETOnew_table_name例如ALTERTABLEadmin_userRENAMETOa_userMySQL添加字段:altertable`user_movement_log` AddcolumnGatewayIdintnotnulldefault0AFTER`Regionid`(在哪个字段后面添加) 删除字段:altertable`user_movement_log`dropcolumnGatewayid 调整字段顺序:ALTERTABLE`user_movement_log`CHANGE`GatewayId``Gatew 阅读全文