user2144306 user2144306 - 4 months ago 22
MySQL Question

Python mySQL Update, Working but not updating table

I have a python script which needs to update a mysql database, I have so far:

dbb = MySQLdb.connect(host="localhost",
user="user",
passwd="pass",
db="database")
try:
curb = dbb.cursor()
curb.execute ("UPDATE RadioGroups SET CurrentState=1 WHERE RadioID=11")
print "Row(s) were updated :" + str(curb.rowcount)
curb.close()
except MySQLdb.Error, e:
print "query failed<br/>"
print e


The script prints
Row(s) were updated :
with the correct number of rows which have a
RadioID
of 11. If I change the
RadioID
to another number not present in the table it will say
Row(s) were updated :0
. However the database doesn't actually update. The
CurrentState
field just stays the same. If I copy and past the SQL statement in to PHPMyAdmin it works fine.

Answer

use

dbb.commit()

after

curb.execute ("UPDATE RadioGroups SET CurrentState=1 WHERE RadioID=11")

to commit all the changes that you 'loaded' into the mysql server

Comments