MySQL Check if table exists error
- by Max van Heiningen
I'm trying to check if a table already exists, however I can't get this working.
IF EXISTS (SELECT 1
FROM sysobjects
WHERE xtype='u' AND name='tablename')
SELECT 'table already exists.'
ELSE
BEGIN
CREATE TABLE Week_(
id INT(10)AUTO_INCREMENT PRIMARY KEY (id),
...
...)
END;
My error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
near 'IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name' at
line 1
Can someone help me with this?
Thanks in advance