Update Query Syntax Error

Question

i have this 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 'WHERE fID = ''2'' at line 1"

Code:

String query = "UPDATE fooditem SET fName = '"
               +fi.getFName()+"', fDesc = '"
               +fi.getFDesc()+"', fImgDir = '"
               +fi.getFImgDir()+"', fPrice = '"
               +fi.getFPrice()+"', WHERE fID = ''"+fi.getFItemID()+"'";

PreparedStatement ps = conn.prepareStatement(query);

Can someone help me? Thank you!

remove the comma before the WHERE

Nir Alfasi
– Nir Alfasi

2013-10-17 03:07:59 +00:00
Commented Oct 17, 2013 at 3:07 — Nir Alfasi
– Nir Alfasi, Commented Oct 17, 2013 at 3:07

chinna_82 · Accepted Answer · 2013-10-17 03:11:01Z

1

String query = "UPDATE fooditem SET fName = '"
               +fi.getFName()+"', fDesc = '"
               +fi.getFDesc()+"', fImgDir = '"
               +fi.getFImgDir()+"', fPrice = '"
               +fi.getFPrice()+"' WHERE fID = ''"+fi.getFItemID()+"'";

PreparedStatement ps = conn.prepareStatement(query);

Remove the comma before WHERE

answered Oct 17, 2013 at 3:11

chinna_82

6,40318 gold badges83 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Update Query Syntax Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related