update two table with one command MySQL

Question

I have two tables called 'USER' and 'CART' the two tables contain the same column name 'USER_ID'.

If I am to insert a new 'USER_ID' into the 'USER' table, how can I make this 'USER_ID' be in the 'CART' table as well? Using only one command:

INSERT INTO USER (USER_ID) VALUES ('1');

Is there an easy way to do this ?

score 1 · Accepted Answer · edited May 23 '17 at 12:18

1

Tanya, I guess it's not possible to insert into two tables with one query in mysql. You may find your question discussed/answered in the below link.

sql - insert into multiple tables in one query

edited May 23 '17 at 12:18

Community

1
1

answered Sep 28 '12 at 14:04

Selvi Moies

75
8

So I will just have to insert two times? Thanks anyways :) – Sep 28 '12 at 14:08
Yes, whether you use simple query/transaction/trigger, you would need to accomplish it with two insert statements :) – Selvi Moies Sep 28 '12 at 14:15

score 0 · Answer 2 · answered Sep 28 '12 at 13:55

You can't, you can do two statements wrapped in one transaction to insure consistency.

You can use a trigger, but triggers are an anti-pattern at best and the side effects and complexities to say, undo their effects are almost NEVER worth it.

score 0 · Answer 3 · answered Sep 28 '12 at 13:56

0

If your User table is master table and Cart is child table, then you can use.

trigger. Insert after User table you need to insert into Cart table. here is the exact turorial you want.

trigger after insert tutorial.

answered Sep 28 '12 at 13:56

av1987

493
4
12

score 0 · Answer 4 · answered Sep 28 '12 at 13:56

0

Well, you could use triggers and insert the same userid in the cart table.

answered Sep 28 '12 at 13:56

xception

4,241
1
17
27

update two table with one command MySQL

4 Answers4