Update mysql table through python script

Question

I have been trying to use MySql with Python and I had been using mysql connector.

Whenever I use cursor to execute commands, it works while the script is running but when I run the script again, the changes I made are gone.

Please help! Thanks in advance

ruohola · Accepted Answer · 2020-05-09 06:47:47Z

2

You need to commit the changes to the database with:

cursor.commit()

Otherwise they will reset when the cursor gets deleted.

answered May 9, 2020 at 6:00

ruohola

24.8k7 gold badges76 silver badges118 bronze badges

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

1 Comment

Let me try it but I am starting to remember that it is the right one. A very warm thanks bro!!