添加字段(+注释+字段位置):
ALTER TABLE table_name ADD COLUMN columnName columnType COMMENT '注释' AFTER afterColumnName;
删除字段
ALTER TABLE tableName DROP COLUMN columnName;
ALTER TABLE table_name ADD COLUMN columnName columnType COMMENT '注释' AFTER afterColumnName;
ALTER TABLE tableName DROP COLUMN columnName;