syntax error on mysql query to update in python

Question

here is my query

 x.execute("UPDATE details SET name =%s,"(form.newname)"WHERE name =%s," (form.name))

am getting syntax error.can anyone pls help to fix it

Kill the comma after SET and add appropriate spacing: x.execute("UPDATE details SET name = %s"(form.newname)" WHERE name = %s" (form.name)) — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 29, 2016 at 7:02

Simon PA · Accepted Answer · 2016-09-29 07:32:54Z

1

Based on syntax: cursor.execute(sql_query, args)

It should be like:

x.execute("UPDATE details SET name = %s WHERE name = %s", (form.newname, form.name))

answered Sep 29, 2016 at 7:32

Simon PA

74813 silver badges28 bronze badges

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

1 Comment

execute() takes at most 3 arguments (4 given)...am getting like this error

Zaynul Abadin Tuhin · Accepted Answer · 2016-09-29 07:08:29Z

0

If you want to update those name which is ending with the letter "s"

then you have to use LIKE operator in where clause

update destails set name ="adfsf" where name like '%s'

answered Sep 29, 2016 at 7:08

32.1k6 gold badges37 silver badges66 bronze badges

am not trying to update names with letter s .i want to update name from form.name to form.new name<-(these are text boxes)

Harsha Biyani · Accepted Answer · 2016-09-29 07:53:06Z

0

You can try :

x.execute("""UPDATE details SET name = "%s" WHERE name = "%s" """, (form.newname, form.name))

If form.newname and form.name are TEXT fields in database, you have to pass %s with parenthesis "%s"

answered Sep 29, 2016 at 7:53

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges