mysql和postgresql在表中添加/修改字段和注释

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 ‘行业名称’;