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
1490
January 26, 2018 05:01PM
2091
January 26, 2018 06:09PM
1003
January 26, 2018 06:09PM
Re: Syntax error on creating trigger
685
January 26, 2018 08:36PM
669
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.