mySQL syntax error, but there is no error?

Question

It keep getting this SQL error, but I am very certain there are no errors in the query. I have been staring at it too long. Is there something else that might cause this?

INSERT INTO game_data (clue, image, answer, wrong, right) VALUES ('asdf',         'asdf', 'asdf', 'assdf', 'asdf')

Invalid Query: 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 'right) VALUES ('asdf', 'asdf', 'asdf', 'assdf', 'asdf')' at line 1

I have run other queries with this exact code, just swapping out the variables, and it works.

and for good measure, there is the php that generates this:

$sql = "INSERT INTO game_data (clue, image, answer, wrong, right) VALUES
    ('" . $clue . "', '" . $image . "', '" . $answer . "', '" . $wrong . "', '" . $right . "')";

Incidentally, what kind of value goes in `wrong` and/or `right`? Also, all those ". things are unnecessary — Strawberry, Oct 30 '15 at 06:46

score 11 · Accepted Answer · edited Oct 30 '15 at 20:37

11

right is a reserved keyword in MYSQL. You need to escape it using backticks like this:

INSERT INTO game_data (`clue`, `image`, `answer`, `wrong`, `right`) VALUES

Note: Try to avoid naming your columns as reserved keyword names in future.

edited Oct 30 '15 at 20:37

dnoeth

59,503
4
39
56

answered Oct 30 '15 at 06:34

Rahul Tripathi

168,305
31
280
331

@RobH:- You are welcome! – Rahul Tripathi Oct 30 '15 at 06:38

score 0 · Answer 2 · answered Oct 30 '15 at 06:42

0

The name 'right' is a MySQL reserved keyword. I dont know how can you create 'right' column.

answered Oct 30 '15 at 06:42

hai tran

21
1

1

...well, by enclosing it in back ticks- but better to avoid reserved words altogether – Strawberry Oct 30 '15 at 06:45

mySQL syntax error, but there is no error?

2 Answers2