Syntax error: 'missing semicolon' when creating a MySQL trigger

Question

My trigger query:

CREATE DEFINER = CURRENT_USER TRIGGER `test`.`users_AFTER_INSERT` AFTER INSERT ON `users` FOR EACH ROW
BEGIN
 UPDATE test.users
 SET enabled=1
    FROM Inserted i
    WHERE username = i.username
END

It complains about this part: SET enabled=1. I have tried adding quotes, didn't help.

Most likely the syntax is wrong, but I can't figure out what exactly is wrong here.

EDIT:

Or could it be done like this?

CREATE DEFINER = CURRENT_USER TRIGGER `test`.`users_AFTER_INSERT` AFTER INSERT ON `users` FOR EACH ROW
BEGIN
 UPDATE test.users
 SET enabled=1
 WHERE username = NEW.username;
END

I thought Inserted would be enough, just like NEW, now I have doubts. Could I use NEW instead? — Ondrej Tokar
– Ondrej Tokar, Commented Feb 21, 2016 at 10:14

Gouda Elalfy · Accepted Answer · 2016-02-21 10:17:52Z

1

remove from inserted query:

delimiter | 
CREATE DEFINER = CURRENT_USER TRIGGER `test`.`users_AFTER_INSERT` AFTER INSERT ON `users` FOR EACH ROW
BEGIN
 UPDATE test.users
 SET enabled=1
    WHERE username = i.username;
END
| 
delimiter ;

answered Feb 21, 2016 at 10:17

Gouda Elalfy

7,0833 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error: 'missing semicolon' when creating a MySQL trigger

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