SQL syntax error when creating table if it doesn't already exist

Question

#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 'EXIST users ( id int(11) NOT NULL AUTO_INCREMENT, username varchar(255' at line 1

CREATE TABLE IF NOT EXIST `users` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `username` varchar(255) NOT NULL,
 `first_name` varchar(255) NOT NULL,
 `last_name` varchar(255) NOT NULL,
 `email` varchar(255) NOT NULL,
 `password` varchar(32) NOT NULL,
 `sign_up_date` date NOT NULL,
 `activated` enum('0','1') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

This question was caused by a simple typographical error.

Kermit
– Kermit

2014-01-13 19:26:30 +00:00
Commented Jan 13, 2014 at 19:26 — Kermit
– Kermit, Commented Jan 13, 2014 at 19:26

LorDex · Accepted Answer · 2014-01-12 23:51:25Z

3

EXISTS!

CREATE TABLE IF NOT EXISTS users ( id int(11) NOT NULL AUTO_INCREMENT, username varchar(255) NOT NULL, first_name varchar(255) NOT NULL, last_name varchar(255) NOT NULL, email varchar(255) NOT NULL, password varchar(32) NOT NULL, sign_up_date date NOT NULL, activated enum('0','1') NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

answered Jan 12, 2014 at 23:51

LorDex

2,6382 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vickel · Accepted Answer · 2014-01-13 00:09:21Z

3

You have a syntax error in your sql:

 EXIST

should be

 EXISTS

edited Jan 13, 2014 at 0:09

answered Jan 12, 2014 at 23:54

Vickel

7,9906 gold badges40 silver badges63 bronze badges

Collectives™ on Stack Overflow

SQL syntax error when creating table if it doesn't already exist

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related