How to use an UPDATE SQL statement with user input from Python?

Question

I'm new to Python and especially to SQL.

My goal is:

A user should enter which phone number he wants to change
Then the user should be able to enter the new phone number
This change should then be stored in my MySQL database

As I know the syntax for an update is like this:

sql = "UPDATE table SET fieldname = value" "WHERE fieldname = value"

But if I try to use the code with two variables from an input, it doesn't work:

input_change = input("Write the number to change: ")
input_new = input("Write the new number: ")
sql = "UPDATE table SET telefonnummer = ?" "WHERE telefonnummer = ?"
cursor.execute(sql, (input_change, input_new))
connection.commit()

Does somebody have an idea how I can fix this? Or where can I find a good description about using variables in SQL statements?

Many thanks for the answers.

Hello user148, could you try changing this sql = "UPDATE table SET telefonnummer = ?" "WHERE telefonnummer = ?" to sql ='''UPDATE table SET telefonnummer = ? WHERE telefonnummer = ?''' — Ice Bear
– Ice Bear, Commented Dec 20, 2020 at 16:15

Ice Bear · Accepted Answer · 2020-12-20 16:17:28Z

1

Change :

sql = "UPDATE table SET telefonnummer = ?" "WHERE telefonnummer = ?"

to

sql = "UPDATE table SET telefonnummer = ? WHERE telefonnummer = ?"

and

cursor.execute(sql, (input_change, input_new))

to

cursor.execute(sql, [input_change, input_new])

edited Dec 20, 2020 at 16:17

Ice Bear

4,2562 gold badges14 silver badges27 bronze badges

answered Dec 20, 2020 at 16:15

Nir Elbaz

6362 gold badges7 silver badges20 bronze badges

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

4 Comments

Ice Bear Over a year ago

Cool! This sums it up, I got confused I thought the input() is only one. I think the code looks different in night mode :D

user14858919 Over a year ago

Hello Nir Elbaz & StackOffended Many thanks for your answers. Now I don't get an error anymore, but the update of the phone number does not happen in the database...

user14858919 Over a year ago

It works with this code you had written! :)) I had just to change the sequence here [input_new, input_change]. Thank you very much!

Ice Bear Over a year ago

great! If I'm not mistaken making it a tuple or a list I think won't matter , either of the two I think would work as long as it provides the data correspondingly :)

Collectives™ on Stack Overflow

How to use an UPDATE SQL statement with user input from Python?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related