create_trigger_dele_student.sql

来自「一个挺好的招生管理系统」· SQL 代码 · 共 11 行

create or replace trigger delete_student
before delete on student
for each row
begin
delete from score where 号码=:old.编号;
if(:old.录取状态=1) then
update college set 录取人数=录取人数-1 where 院校编号=:old.录取院校;
end if;
end;
/