当student表的stuName字段更新时,
将更新后的stuName同步到rmstuitemfeeinfo表中,
条件是student.stuid=rmstuitemfeeinfo.studentid
【注】:new.stuname表示更新后的值,:old.stuid表示更新之前的值
CREATE OR REPLACE
TRIGGER TRIGGER_STUNAME
BEFORE UPDATE OF STUNAME ON STUDENT
FOR EACH ROW
BEGIN
update rmstuitemfeeinfo set studentname=:new.stuname where studentid=:old.stuid;
END;