MySQL trigger with 2 queries

Question

I want to make a trigger to a certain table that makes it so that when I insert data into that table, two other tables are updated. I am trying to do something like this, on the trigger section of phpMyAdmin:

INSERT INTO db.tableOne (id, name, country) VALUES (NEW.id, NEW.name, NEW.country);

INSERT INTO db.tableTwo (id, colour, price) VALUES (NEW.id, NEW.colour, NEW.price);

It gives me a syntax error.

I tried creating 2 different triggers for the same action on that table but it says that I can't have 2 triggers for the same action. Any help is deeply appreciated!

Ok, solved. For anyone who has the same problem, it's quite easy actually: just put a "BEGIN" statement before the "INSERT" statements, and a "END" statement after. — Luís Ferreira
– Luís Ferreira, Commented Jan 24, 2013 at 22:43
You should select the 'Solve/Answer your own question' option and put your comment in there. Thanks for the update! — N1tr0
– N1tr0, Commented Jan 25, 2013 at 20:40

Luís Ferreira · Accepted Answer · 2013-03-10 12:54:27Z

3

Ok, solved. For anyone who has the same problem, it's quite easy actually: just put a "BEGIN" statement before the "INSERT" statements, and a "END" statement after.

answered Mar 10, 2013 at 12:54

Luís Ferreira

2,6363 gold badges22 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

MySQL trigger with 2 queries

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