MYSQL: Create Table If Not Exists

Question

1.29M viewsSeptember 10, 2022mysql sql

4

Marin September 7, 2022 0 Comments

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?

score 4 · Answer 1 · 2022-09-07T08:30:19+00:00

4

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

score 9 · Answer 2 · 2022-09-07T02:19:21+00:00

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