MySQL Forums
Forum List  »  Triggers

Re: Trigger AFTER_UPDATE to only run IF NOT EXISTS
Posted by: Peter Brawley
Date: September 06, 2016 06:09PM

Your explanation is sketchy, but something like this ...

if not exists( select id_caso from fish where id_caso=new.id_caso) then
-- insert code
end if;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Trigger AFTER_UPDATE to only run IF NOT EXISTS
1045
September 06, 2016 06:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.