Re: Syntax error on creating trigger

[Danon Knox]

I changed it to this:

DELIMITER #

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

DELIMITER ;

And this is the error I got:
Error

SQL query:

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

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END
DELIMITER' at line 5

This is my version info:
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.20-0ubuntu0.16.04.1-log - (Ubuntu)
Protocol version: 10