Updating database with MySQLdb in Python

Question

I'm currently trying to make changes to a table using the MySQLdb module with Python, but for some reason the change is not actually occurring. I'm definitely connecting fine, because I can fetch a result so for some reason the update is not working. Code is as follows

import MySQLdb

db = MySQLdb.connect(host="localhost", user="root", passwd="", db="rpi")
cur = db.cursor()
cur.execute("UPDATE heating SET mode = 'change'")

cur.close()
db.close()

There is only one row in the table heating. I am not yet running this from a Raspberry Pi.

Why is the database not being updated? I'm not too sure how to get an error with the MySQLdb module, so help with that would be appreciated too, if not required to fix this issue.

Alexander · Accepted Answer · 2015-04-30 01:46:37Z

2

You need to commit your SQL statement after executing it:

db.commit()

answered Apr 30, 2015 at 1:46

Alexander

110k32 gold badges212 silver badges208 bronze badges

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

Collectives™ on Stack Overflow

Updating database with MySQLdb in 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