SQL syntax in insert into

Question

I wrote this code:

mysql_query("INSERT INTO test (user_id, word_id, right) VALUES ('6', '23', '5' )") or die(mysql_error());

But an error message prompts:

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 ('6', '23', '5' )' at line 1

What I did wrong?

You should not use character literals for numbers. '6' is a character, 6 is a number. — user330315
– user330315, Commented Dec 10, 2012 at 11:22

Mahmoud Gamal · Accepted Answer · 2012-12-10 11:40:27Z

4

right is a reserved word , escape it like so:

INSERT INTO test (user_id, word_id, `right`) VALUES ('6', '23', '5' )

Note that:¹

Use of this extension(mysql_query) is discouraged. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
mysqli_query()
PDO::query()

^{1:^{quoted from PHP Manual: mysql_query}}

edited Dec 10, 2012 at 11:40

answered Dec 10, 2012 at 11:17

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

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

1 Comment

Gago Design Over a year ago

Thanks a lot! What are the other reserved words?

NullPoiиteя · Accepted Answer · 2012-12-10 11:32:04Z

2

right is reserved key word 9.3. Reserved Words when we use reserved keyword we need to escape them try

mysql_query("INSERT INTO test (user_id, word_id, `right`) VALUES ('6', '23', '5' )") or die(mysql_error());

enter image description here

edited Dec 10, 2012 at 11:32

answered Dec 10, 2012 at 11:17

NullPoiиteя

57.3k23 gold badges130 silver badges148 bronze badges

Comments

Sashi Kant · Accepted Answer · 2012-12-10 11:18:23Z

0

Try this :::RIGHT is known keyword, try a backtick

INSERT INTO test (`user_id`, `word_id`, `right`) VALUES ('6', '23', '5' )

answered Dec 10, 2012 at 11:18

Sashi Kant

13.5k9 gold badges50 silver badges71 bronze badges

Comments

rOcKiNg RhO · Accepted Answer · 2012-12-10 11:38:12Z

0

INSERT INTO `test` (`user_id`, `word_id`, `right`) VALUES ('6', '23', '5' )

answered Dec 10, 2012 at 11:38

rOcKiNg RhO

6311 gold badge6 silver badges16 bronze badges

Collectives™ on Stack Overflow

SQL syntax in insert into

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related