MySQL update column with Python

Question

I am trying to update three columns in my table with data by using Python variables, but I have ran into an issue which I don't seem to understand.

I have done some amendments but still run into issues, can anyone see what I am doing wrong?

My table:

Columns   id   code    url       val1    val2    val3
Data      1    A2941   url.com   NULL    NULL    NULL

My query:

cursor.execute("UPDATE mytable SET val1=%s", (myVar))

Error message:

mysql.connector.errors.ProgrammingError: 1064 (42000): 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 '%s' at line 1

Mureinik · Accepted Answer · 2020-03-28 18:52:14Z

1

execute takes a tuple as its second argument. (myVar) is just the myVar variable surrounded in parenthesis. To create a tuple that contains only myVar, you need to add a comma:

cursor.execute("UPDATE mytable SET val1=%s", (myVar,))
# Here --------------------------------------------^

answered Mar 28, 2020 at 18:52

Mureinik

316k54 gold badges398 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

MySQL update column with Python

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