How to debug MySQL "You have an error in your SQL syntax error"

Question

This is the error

Could not enter data: 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 ')' at line 1

This is my query

$sql = 'INSERT INTO list '. 
   '(bond_amount,bond,prize,prize_amount,draw,draw_date,held_at) '.
   'VALUES ( "bonds", "bonds", prize, p_amount, draw, d_date, held,)';

Also consider that you can use native sql functions if you need the current date to be automatically filled in. Just insert a null value to this field (for example "updated" i/o using the "current_date" keyword). For mysql, you just have to declare a timestamp field with "CURRENT_TIMESTAMP" as defaut value. — hornetbzz
– hornetbzz, Commented Mar 17, 2011 at 5:21

Jim Garrison · Accepted Answer · 2011-03-17 05:14:26Z

5

current_date is a reserved word in mysql. You should avoid it, but if you really want to use it, you must quote it (in back-quotes).

answered Mar 17, 2011 at 5:14

Jim Garrison

87k20 gold badges162 silver badges197 bronze badges

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

Comments

Gaurav · Accepted Answer · 2011-03-17 05:13:07Z

4

You can not use current_date as column name. It is a reserve words of mysql.

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

answered Mar 17, 2011 at 5:13

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

1 Comment

NanoPish Over a year ago

how to debug it tho

xkeshav · Accepted Answer · 2011-03-17 05:20:58Z

3

try

INSERT INTO staff_service (customer_id,workorder_no,service_date,`current_date`) 
VALUES (2,021,'3112-21-1',CURDATE())

answered Mar 17, 2011 at 5:20

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

Comments

Awais Qarni · Accepted Answer · 2011-03-17 05:23:17Z

0

If You want to use current_date as column name then put current_date between ``(back quotes)

edited Mar 17, 2011 at 5:23

answered Mar 17, 2011 at 5:17

Awais Qarni

18k25 gold badges80 silver badges145 bronze badges

Collectives™ on Stack Overflow

How to debug MySQL "You have an error in your SQL syntax error"

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related