MySQL Forums
Forum List  »  Triggers

Re: Syntax error on creating trigger
Posted by: Danon Knox
Date: January 26, 2018 08:36PM

Thank you very much for the help. The following syntax worked:

CREATE TRIGGER updateK2TagCloud AFTER INSERT ON wx4rb_core_log_searches FOR EACH ROW insert into wx4rb_k2_tags (name,published) values (NEW.search_term,1)

Options: ReplyQuote


Subject
Views
Written By
Posted
1512
January 26, 2018 05:01PM
2116
January 26, 2018 06:09PM
1012
January 26, 2018 06:09PM
Re: Syntax error on creating trigger
695
January 26, 2018 08:36PM
680
January 26, 2018 08:36PM


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.