mysql
添加
字符串类型
ALTER TABLE hotel_order
ADD COLUMN book_remark
varchar(100) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT ‘备注’ AFTER state
;
数字类型
ALTER TABLE edu_enterprise_training
ADD COLUMN should_learn_times
decimal(12,2) DEFAULT null COMMENT ‘应学习人次’ AFTER issue_certificates_rate
;
修改
ALTER TABLE hotel_order
MODIFY COLUMN book_user
varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘预定人’ AFTER book_time
;
postgresql
新增
alter table edu_industry_training_score_ranking add industry varchar(50) ;
COMMENT ON COLUMN edu_industry_training_score_ranking.industry IS ‘行业名称’;