Create table : Syntax error

Question

CREATE TABLE IF NOT EXISTS 'wp_gom_my_project' (
'my_project_id' int NOT NULL auto_increment,
'my_project_name' text NOT NULL ,
'user_id' int NOT NULL ,
'my_project_description' text NOT NULL ,
'my_project_deadline' datetime NOT NULL ,
PRIMARY KEY  (`my_project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

I just can't find the error.

This is the error message:

#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 ''wp_gom_my_project' ( 'my_project_id' int NOT NULL auto_increment, 'my_project' at line 1

sqlfiddle.com/#!2/07f2a

Naveen Kumar Alone
– Naveen Kumar Alone

2013-09-22 20:04:35 +00:00
Commented Sep 22, 2013 at 20:04 — Naveen Kumar Alone
– Naveen Kumar Alone, Commented Sep 22, 2013 at 20:04

IMSoP · Accepted Answer · 2013-09-22 19:57:09Z

5

You have the wrong kind of quotes:

' is for quoting strings
` is for quoting identifiers (table names, column names, etc)

Since none of your table or column names would be a keyword anyway, just don't put any quotes at all, and it will look much nicer. :)

answered Sep 22, 2013 at 19:57

IMSoP

99.7k18 gold badges135 silver badges183 bronze badges

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

Comments

Naveen Kumar Alone · Accepted Answer · 2013-09-22 20:03:00Z

1

Dont put any quotes, use `

Try this one

Here is reference fiddle or another one with `

CREATE TABLE IF NOT EXISTS wp_gom_my_project (
my_project_id int NOT NULL auto_increment,
my_project_name text NOT NULL ,
user_id int NOT NULL ,
my_project_description text NOT NULL ,
my_project_deadline datetime NOT NULL ,
PRIMARY KEY  (`my_project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

Or replace ' with `

edited Sep 22, 2013 at 20:03

answered Sep 22, 2013 at 19:57

Naveen Kumar Alone

7,6985 gold badges40 silver badges59 bronze badges

Comments

Smar · Accepted Answer · 2013-09-22 19:57:00Z

0

Table name and other fields should not be quoted.

Try

CREATE TABLE IF NOT EXISTS wp_gom_my_project (
my_project_id int NOT NULL auto_increment,
my_project_name text NOT NULL ,
user_id int NOT NULL ,
my_project_description text NOT NULL ,
my_project_deadline datetime NOT NULL ,
PRIMARY KEY  (`my_project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

instead.

answered Sep 22, 2013 at 19:57

Smar

8,6723 gold badges38 silver badges49 bronze badges

Comments

Jason OOO · Accepted Answer · 2013-09-22 19:57:16Z

0

Table name and column names should not be enclosed with single or double quotes. you can use backticks `

answered Sep 22, 2013 at 19:57

Jason OOO

3,5622 gold badges28 silver badges32 bronze badges

Comments

knittl · Accepted Answer · 2013-09-22 19:57:42Z

0

Single quotes denote a string value in MySQL. If you want to quote table names, you have to use a backtick:

CREATE TABLE IF NOT EXISTS `wp_gom_my_project` (
  `my_project_id` int NOT NULL auto_increment,
  `my_project_name` text NOT NULL ,
  `user_id` int NOT NULL ,
  `my_project_description` text NOT NULL ,
  `my_project_deadline` datetime NOT NULL ,
  PRIMARY KEY  (`my_project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

answered Sep 22, 2013 at 19:57

knittl

269k59 gold badges339 silver badges405 bronze badges

Comments

Kamil Chaber · Accepted Answer · 2013-09-22 19:59:01Z

0

Use `(back quote) instead of '(apostrophe) when difining column and table names

answered Sep 22, 2013 at 19:59

Kamil Chaber

5881 gold badge10 silver badges28 bronze badges

Collectives™ on Stack Overflow

Create table : Syntax error

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related