Python SQlite3 Update function, sqlite3.OperationalError: near "WHERE": syntax error

Question

I'm trying to update an item in my database for the relevant field which is identified by an OrderID.

 cursor.execute("UPDATE Customer_Orders SET Progress=?, WHERE OrderID=?", 
 ("Completed", tableOrderInfo[0],))

However, I keep getting this syntax error and I don't know why.

 sqlite3.OperationalError: near "WHERE": syntax error

Ashutosh Chapagain · Accepted Answer · 2018-12-07 14:36:21Z

1

UPDATE Customer_Orders SET Progress=? WHERE OrderID=?

remove the comma before WHERE.

See more about UPDATE in SQL here.

answered Dec 7, 2018 at 14:36

9269 silver badges15 bronze badges

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

1 Answer 1