mysql - mysql触发器语句中的别名

Question

我尝试使用别名创建触发器，但收到错误:

delimiter |
create trigger death before insert on retiree_hist RH
for each row 
begin 
delete from myjobdata JD
where JD.emplid = RH.emplid; 
end;|
delimiter ;

我了解到别名不能与触发器一起使用。有没有办法解决？

Answer 1

delimiter |
create trigger death before insert on retiree_hist
for each row 
begin 
   delete from myjobdata
   where myjobdata.emplid = NEW.emplid; 
end
|
delimiter ;