Syntax error in creating Trigger in mysql

Question

m writing following lines for creating a trigger:

create trigger notify after insert on applications
for each row
begin
insert into notifications SET sno=1;
end;

but everytime i get following error:

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 '' at line 4

line 4 is - insert into notifications SET sno=1

Well, the INSERT query is wrong.

Bart Friederichs
– Bart Friederichs

2013-04-07 19:48:48 +00:00
Commented Apr 7, 2013 at 19:48 — Bart Friederichs
– Bart Friederichs, Commented Apr 7, 2013 at 19:48

Bart Friederichs · Accepted Answer · 2013-04-07 19:54:28Z

1

MySQL is confused about the delimiters. It thinks the first ; is the end of the TRIGGER declaration (which it is not). Use delimiter to change it temporarily, and later to change it back:

delimiter |
create trigger notify after insert on applications
for each row
begin
insert into notifications (sno) values (1);
end;
|
delimiter ;

Collectives™ on Stack Overflow

Syntax error in creating Trigger in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related