Error in mysql insert statement

Question

This is the query i am running to insert a record but i am getting an error i am not able to get what is the problem.

INSERT INTO lft(Patientid,Patientname,Testdate,Test,Range,Result)
VALUES('$Patientid','$Patientname','$Testdate','$Test','$Range','$Result')

The error is :

ERROR 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 'Range,Result)VALUES('1052','ADITYA RAJESH KHATEKE','4/3/2012','CHest','30','23')' at line 1

http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html — sachleen, Apr 27 '13 at 05:21

Yogesh Suthar · Accepted Answer · 2013-04-27T05:23:34.353

5

RANGE is reserved word in mysql use ` around it

INSERT INTO lft(`Patientid`,`Patientname`,`Testdate`,`Test`,`Range`,`Result`)
VALUES('$Patientid','$Patientname','$Testdate','$Test','$Range','$Result')

edited Apr 27 '13 at 05:23

answered Apr 27 '13 at 05:20

Yogesh Suthar

30,424
18
72
100

score 1 · Answer 2 · answered Apr 27 '13 at 05:22

1

You need to put you query like this

INSERT INTO lft(`Patientid`,`Patientname`,`Testdate`,`Test`,`Range`,`Result`)VALUES('$Patientid','$Patientname','$Testdate','$Test','$Range','$Result')

Range is a reserved keyword.

answered Apr 27 '13 at 05:22

chandresh_cool

11,753
3
30
45

3

Answer already given. – Rikesh Apr 27 '13 at 05:22

Error in mysql insert statement

2 Answers2