0
[SOLVED] Will the query 'CREATE TABLE IF NOT EXISTS table_name' raise an error if the table exists?
Currently I'm developing a database app. I want to ensure that the table in user's database exists. If there is no table, I want to create it automatically. Will the query 'CREATE TABLE IF NOT EXISTS' work? Info : I need clarification if the table exists, so I need an exception raised.
2 Answers
+ 1
table creation queries will fail if the table already exists.
+ 1
and yes it should work