Re: Creating Trigger.. New to this obviously

[Peter Brawley]

Quote

CREATE TRIGGER Update_Directory AFTER INSERT ON wpin_gm_user_entries UPDATE wpin_gm_user_entries SET download_link = REPLACE(download_link, 'uploads', 'gravity2pdf') ;

Please read more carefully the manual page for Triggers.

1. Your syntax is missing ...For Each Row...

2. A Trigger cannot itself issue an Update command on the table for which it is defined (eg such could induce an infinite loop). As the manual page says, changing values in the defined row needs SET NEW.columnName syntax.

If you get stuck correcting these errors, please post the result of Show Create Table result for the table, and the detailed requirement for the Trigger with an example.



Edited 1 time(s). Last edit at 03/14/2019 09:04PM by Peter Brawley.