MySQL Version 5.5 syntax errors when importing sql file

Question

I try to import sql file to my database. the query is :

CREATE TABLE 'project' (
  `id`              int(11) NOT NULL AUTO_INCREMENT,
  `name`            varchar(255) NOT NULL,
  `description`     text NOT NULL,
  `creat_time`      datetime DEFAULT NULL,
  `create_user_id`  int DEFAULT NULL,
  `update_time`     datetime DEFAULT NULL,
  `update_user_id`  INTEGER DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

The error information is :

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 ''project' ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(25' at line 1)

But I did not see any errors from my query. Anyone can give me advises?

create_time would be better than creat_time

Jason Heo
– Jason Heo

2013-11-07 15:46:08 +00:00
Commented Nov 7, 2013 at 15:46 — Jason Heo
– Jason Heo, Commented Nov 7, 2013 at 15:46

Filipe Silva · Accepted Answer · 2013-11-07 15:39:36Z

1

Remove the singlequotes ( ' ) around table name ( 'project' ):

CREATE TABLE project (
  `id`              int(11) NOT NULL AUTO_INCREMENT,
  `name`            varchar(255) NOT NULL,
  `description`     text NOT NULL,
  `creat_time`      datetime DEFAULT NULL,
  `create_user_id`  int DEFAULT NULL,
  `update_time`     datetime DEFAULT NULL,
  `update_user_id`  INTEGER DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

SQLFIDDLE DEMO

Single quotes are used for string values. There you can use ` backticks if you want, but you might as well don't use anything.

answered Nov 7, 2013 at 15:39

Filipe Silva

21.7k6 gold badges56 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

MySQL Version 5.5 syntax errors when importing sql file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related