[MySQL] 修改表结构

• 追加一列到表最后

alter table table_name add new_column_name new_column_type;

• 追加一列到表最前

alter table table_name add new_column_name new_column_type first;

• 追加一列到表的任意位置

alter table table_name add new_column_name new_column_type after column_name;

• 将一列追加到另一列的后边

alter table table_name modify column_name1 after column_name2;

• 修改表的字段类型

alter table table_name modify column_name new_column_type;

• 修改列名及类型

alter table table_name change column_name new_column_name new_column_type;

• 删除列

alter table table_name drop column_name;