MYSQL: create a table if it does not exist

If I do Create a table, if it does not exist , and a table with the same name exists with fewer rows (or columns), what will happen?

+4
source share
2 answers

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

+8
source

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

+4
source

All Articles