SQL-Creating Table Question

[Php_Beginner2]

Hi there,

What is the different between "CREATE TABLE IS NOT EXIST" and
"CREATE TABLE" in the SQL file?

[Derokorian]

Well first off it most likely says "CREATE TABLE IF NOT EXISTS" Which means that if a table with the specified name already exists, then this create table statement will not be executed (aka if you try to create a table this way that already exists, it won't make a new table and won't throw an error) however without the "IF NOT EXISTS" part if the table already exists then an error will be thrown because you are trying to define a table that is already defined.

[johanafm]

It's IF not IS. The first one only tries to create the table if it doesn't exist. The second one tries to create a table no matter what (and fails if it exists).