Mysql multiple table creation

Question

Is there a possibility to execute multiple CREATE TABLE within one mysql query?

Polynomial · Accepted Answer · 2011-11-21 14:22:57Z

2

No. You must do them in multiple queries.

<incorrect>However, you can wrap the creation queries in a transaction to allow you to roll back the entire operation if something fails.</incorrect>

UPDATE: Ok, as pilcrow points out, each create causes an implicit commit, so you can't use transactions for this. You can, however, wrap the inserts (for a backup restore) in transactions.

edited Nov 21, 2011 at 14:22

answered Nov 21, 2011 at 13:46

Polynomial

28.4k13 gold badges86 silver badges110 bronze badges

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

2 Comments

pilcrow Over a year ago

No, you cannot ROLLBACK multiple table creation statements — like many DDL statements they cause an implicit commit

Polynomial Over a year ago

@pilcrow - Wasn't aware of that. I'll update to reflect that fact.

Collectives™ on Stack Overflow

Mysql multiple table creation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related