MySQL Forums
Forum List  »  Triggers

Re: Creating Trigger.. New to this obviously
Posted by: Colin Haime
Date: March 14, 2019 09:40PM

Thank you for the quick reply and advice.

I changed my syntax to the following:

CREATE TRIGGER `Update pdf` BEFORE INSERT ON `wpin_gm_user_entries`
FOR EACH ROW SET new.download_link = REPLACE(new.download_link,'uploads', 'gravity2pdf')

and it appears to work perfectly.

Mr.Brawley, I thank you very much for the information!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Creating Trigger.. New to this obviously
583
March 14, 2019 09:40PM


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.