Error in mysql syntax - Insert into query

Question

All the column names are correct and data types should be fine, but this throws:

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 'desc, owner, burl) VALUES ('1', '2', '3', '4', '5')' at line 1

mysql_query("INSERT INTO servers (ip, name, desc, owner, burl) VALUES ('1', '2', '3', '4', '5')") or die(mysql_error());

Pentium10 · Accepted Answer · 2011-05-22 20:07:57Z

1

mysql_query("INSERT INTO servers (ip, name, `desc`, owner, burl) VALUES ('1', '2', '3', '4', '5')") or die(mysql_error());

Make sure you backtick column names that uses special words like DESC

answered May 22, 2011 at 20:07

Pentium10

209k124 gold badges435 silver badges513 bronze badges

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

1 Comment

MarkRobbo Over a year ago

Thanks very much, didnt know it was a special word

hvgotcodes · Accepted Answer · 2011-05-22 20:09:05Z

0

desc is a reserved word.

see http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

answered May 22, 2011 at 20:09

hvgotcodes

121k33 gold badges209 silver badges237 bronze badges

Collectives™ on Stack Overflow

Error in mysql syntax - Insert into query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related