CODEWITHSUNDEEP
mysqltriggersalias
TheBandit
TheBandit

Reputation: 109

Aliases in mysql trigger statements

I am trying to create a trigger using aliases, but I get an error:

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 ;

I learned that aliases don't work with triggers. Is there any way around this?

Upvotes: 0

Views: 212

Answers (1)

juergen d
juergen d

Reputation: 204854

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

Upvotes: 1

Related Questions