createtrigger4.sql

学生信息管理系统

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