【数据库】触发器

create trigger trigger_name
　　on {table_name | view_name}
　　{for | After | Instead of }
　　[ insert, update,delete ]
　　as
　　sql_statement

create trigger sc_t
after update of grade on sc
referencing 
   oldrow as oldtuple
   newrow as newtuple
for each row
when (newtuple.grade >= 1.1 *oldtuple.grade)
insert into sc_u (sno,cno,oldgrade,newgrade)
values(oldtuple.sno,oldtuple.cno,oldtuple.grade,newtuple.grade)

create trigger sc_t
after inserted
referencing 
   new table as delta
for each statement
insert into studentInsertlog(Numbers)
select count(*) from delta

create trigger insert_or_update_sal
before insert or update on teacher
referencing new row as newtuple
for each row
begin 
if (newtuple.kob=‘教授‘)and(newtuple.sal<4000)
  then newtuple.sal=4000
end if 
end