MYSQL: Create Table If Not Exists

Question

If I do a Create Table If Not Exists, and a table with the same name exists with fewer rows (or columns), what would happen?

Mark Biek · Accepted Answer · 2008-10-27 16:05:42Z

9

The table will not be created if a table with the same name already exists regardless of table layout.

Mark Biek

152k54 gold badges160 silver badges201 bronze badges

answered Oct 27, 2008 at 15:57

Robert Gamble

110k26 gold badges149 silver badges138 bronze badges

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

Comments

Bill the Lizard · Accepted Answer · 2008-10-27 15:56:37Z

4

Nothing. If the "IF Not Exists" clause fails, the rest of the create is skipped.

answered Oct 27, 2008 at 15:56

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges