Error in mysql insert query

Question

Not able to find what is the error in this MySQL query.

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...

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `root` varchar(255) NOT NULL,
  `name` text NOT NULL,
  `slug` text NOT NULL,
  PRIMARY KEY (`id`)
)

INSERT INTO 'files' ('root', 'name') VALUES ('jvfs2rbpmasor7','Boxes_Teal.png');

Mr. Alien · Accepted Answer · 2013-07-20 15:37:22Z

1

You are using quotes for your table names which is invalid, should use ` back tick

INSERT INTO `files` (`root`, `name`) VALUES ('jvfs2rbpmasor7','Boxes_Teal.png');

You are using PHP so you should use functions which will throw you friendly errors to debug your query, like

if(!$query) echo 'Error '.mysqli_error($connection);

answered Jul 20, 2013 at 15:37

Mr. Alien

158k36 gold badges307 silver badges287 bronze badges

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

2 Comments

Mr. Alien Over a year ago

@CODESEEK Yes it will, you have to use back ticks if you use mysql reserved keywords as column names(which you should avoid always), so backticks in your query won't harm,its just like an extra secirity

Andy Lester Over a year ago

Never use backticks. They are just one more way for you to make syntax errors. The only reason you need them is if you have a column name that is a reserved word, and using column names that are reserved words is a terrible idea as well, so that's two bad habits you can avoid at once.

Ben · Accepted Answer · 2013-07-20 15:47:21Z

1

The issue is, I believe, that when you are specifying table names and column names, you should use backticks (`).

Solution:

Change the following line:

INSERT INTO 'files' ('root', 'name') VALUES ('jvfs2rbpmasor7','Boxes_Teal.png');

...to:

INSERT INTO `files` (`root`, `name`) VALUES ('jvfs2rbpmasor7','Boxes_Teal.png');

answered Jul 20, 2013 at 15:47

Ben

8,9519 gold badges48 silver badges82 bronze badges

1 Comment

CODE SEEK Over a year ago

Thanks. @Ben Pearl Kahan

Collectives™ on Stack Overflow

Error in mysql insert query

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related