Python mySQL更新，正在工作但未更新表 [英] Python mySQL Update, Working but not updating table

问题描述

到目前为止，我有一个需要更新mysql数据库的python脚本:

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  

脚本以正确的行数打印Row(s) were updated :，其中RadioID为11.如果将RadioID更改为表中不存在的其他数字，它将显示Row(s) were updated :0.但是，数据库实际上并没有更新. CurrentState字段保持不变.如果我将SQL语句复制并粘贴到PHPMyAdmin中，则可以正常工作.

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.

推荐答案

使用

dbb.commit()

之后

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

提交您加载"到mysql服务器的所有更改

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

这篇关于Python mySQL更新，正在工作但未更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！