mysql删除增加字段,并添加默认值和注释:

1
2
3
ALTER TABLE edu_teacher_schedule DROP COLUMN PREPARE_TIME;
ALTER TABLE edu_teacher_schedule ADD COLUMN PREPARE_TIME int(11) DEFAULT 300 COMMENT '备课时间,每小节5小时';
UPDATE edu_teacher_schedule SET PREPARE_TIME = 300;