createtrigger4.sql

来自「学生信息管理系统」· SQL 代码 · 共 8 行

create trigger trigger4
on compulsory_score
after update 
as
if(select score from compulsory_score)<60
insert into compulsory_score(note)values('补考')