How to insert into multiple tables in a single statement in MySQL?

Question

All the tables are of the same structure,does MySQL support this kind of operation?

zerkms · Accepted Answer · 2011-05-20 02:59:36Z

2

Nope, it doesn't..............

answered May 20, 2011 at 2:59

zerkms

256k73 gold badges447 silver badges550 bronze badges

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

Comments

Ted Hopp · Accepted Answer · 2011-05-20 03:02:46Z

2

You can do multi-table updates, but not inserts, in a single statement.

answered May 20, 2011 at 3:02

Ted Hopp

235k48 gold badges412 silver badges533 bronze badges

Comments

Dave · Accepted Answer · 2011-05-20 03:07:06Z

This is not possible, but you could execute two (or more!) statements within a single transaction, thus treating the two operations as a single atomic operation. However, by default your database is most likely auto-committing after each statement, thus making a separate transaction for each executed statement. Refer to the manual's section on START TRANSACTION, COMMIT, and ROLLBACK syntax for more information on how to change this.

In general, though, I wouldn't recommend turning off auto-commit unless you're really sure you understand the implications of doing so.

Collectives™ on Stack Overflow

How to insert into multiple tables in a single statement in MySQL?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related