学生成绩管理数据库触发器设计 - 更新总学分、删除选课记录、更新课程号

(1)

CREATE TRIGGER tri_ins_xscj AFTER INSERT ON xscj FOR EACH ROW UPDATE xsqk SET zxf = zxf + NEW.xf WHERE xh = NEW.xh;

(2)

CREATE TRIGGER tri_delete_xskc AFTER DELETE ON xskc FOR EACH ROW DELETE FROM xscj WHERE kch = OLD.kch;

(3)

CREATE TRIGGER tri_update_xskc AFTER UPDATE ON xskc FOR EACH ROW UPDATE xscj SET kch = NEW.kch WHERE kch = OLD.kch;