mysql after的用法_MySQL触发器的正确用法

三、易错问题

而下面的写法虽然语法上没有问题，但是却无法直接写到sql文件中的！原因不明！

------- Error usage

drop trigger if exists delTrigger

create trigger delTrigger after delete on Stud for each row

begin

declare oldsno char(10);

set oldsno=old.sno;

delete from Scsc where sno=oldsno;

end

drop trigger if exists updateTgr

create trigger updateTgr after update on Stud for each row

begin

declare newsno char(10);

declare oldsno char(10);

set newsno = NEW.sno;

set oldsno = OLD.sno;

if newsno<>oldsno then

update Scsc set sno=newsno where sno=oldsno;

end if;

end

------- Error usage

图3