Using MySQL Database Triggers

Question

I have three tables: users, account and accountinfo and I am trying to make a trigger that will add the id from users to the UserID column in the account table. Here is what I tried:

CREATE TRIGGER catchUser BEFORE INSERT ON defaultdatabase.users 
FOR EACH ROW
BEGIN
INSERT INTO defaultdatabase.account(UserID) VALUES (new.id);
END

However, I get an error right after my INSERT statement that says,

Syntax Error: insert 'semicolon'

Why am I getting this error is I have the semicolon or is my trigger just wrong?

I'm using MySQL 5.6 if that makes any difference as well.

Mureinik · Accepted Answer · 2014-12-30 07:45:09Z

1

You need to specify the delimiter:

delimiter //
CREATE TRIGGER catchUser BEFORE INSERT ON defaultdatabase.users 
FOR EACH ROW
BEGIN
INSERT INTO defaultdatabase.account(UserID) VALUES (new.id);
END; //
delimiter ;

answered Dec 30, 2014 at 7:45

Mureinik

316k54 gold badges399 silver badges405 bronze badges

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

Comments

Pathik Vejani · Accepted Answer · 2014-12-30 07:44:15Z

0

Try this:

CREATE TRIGGER catchUser BEFORE INSERT ON defaultdatabase.users 
FOR EACH ROW
BEGIN
INSERT INTO defaultdatabase.account(UserID) VALUES (new.id)
END;

answered Dec 30, 2014 at 7:44

Pathik Vejani

4,49711 gold badges66 silver badges110 bronze badges

Comments

user3111011 · Accepted Answer · 2014-12-30 07:45:48Z

0

Please insert a semicolon after END.

answered Dec 30, 2014 at 7:45

user3111011

1451 silver badge9 bronze badges

Collectives™ on Stack Overflow

Using MySQL Database Triggers

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related