python mysql 表损坏_使用Python的MySQLdb更新MySQL表时出现问题

我尝试使用Python的MySQLdb模块更新MySQL表。尽管查询看起来相当简单，但它不会更新信息。这是我的代码：for username,info in users.iteritems():

if info[0] > 0 and info[1] > 0:

month = 8

year = 2010

cursor.execute("""

UPDATE users_disk

SET

bytes = %s,

quota_in_mb = %s

WHERE

username = %s AND

month = %s AND

year = %s

""", (info[0], info[1], username, month, year))

print "Username: %s; Rowcount: %d" % (username, cursor.rowcount)

输出如下：

^{pr2}$

这意味着没有更新任何行！该表包括以下内容：mysql> select * from users_disk;

+----+----------+-------+------+---------+-------------+

| id | username | month | year | bytes | quota_in_mb |

+----+----------+-------+------+---------+-------------+

| 1 | niu666 | 8 | 2010 | 28672 | 1024000 |

| 2 | antuan | 8 | 2010 | 77824 | 4608000 |

| 3 | tuyo | 8 | 2010 | 28672 | 1024000 |

| 4 | angela | 8 | 2010 | 45056 | 2048000 |

| 5 | felipe | 8 | 2010 | 53248 | 307200 |

| 6 | Meni | 8 | 2010 | 86016 | 4096000 |

| 7 | tronco | 8 | 2010 | 3067904 | 1024000 |

| 8 | queque | 8 | 2010 | 61440 | 4608000 |

| 9 | cerel | 8 | 2010 | 110592 | 5632000 |

+----+----------+-------+------+---------+-------------+

9 rows in set (0.00 sec)

“用户”是一本词典，其内容如下：{'niu666': (28672, 1024000), 'tutk': (-1, -1), 'antuan': (77824, 4608000), 'tolin': (-1, -1), 'tuyo': (28672, 1024000), 'angela': (45056, 2048000), 'felipe': (53248, 307200), 'Meni': (86016, 4096000), 'tronco': (3067904, 1024000), 'queque': (61440, 4608000), 'cerel': (110592, 5632000), 'carok': (-1, -1), 'niu': (-1, -1)}

我认为问题可能与用户名有关，因为如果我删除它，更新工作。但我当然需要用它。。。在

如有任何建议/建议，我们将不胜感激。在

非常感谢你

乌奈·罗德里格斯

---------------更新--------------------

伙计们，我用下面的“丑陋”解决方法。。。这是有效的：for username,info in users.iteritems():

if info[0] > 0 and info[1] > 0:

# The user has positive values, its valid!

cursor.execute("DELETE FROM " + dbtable + " WHERE username = %s AND month = %s AND year = %s", \

(username, month, year))

cursor.execute("INSERT INTO " + dbtable + " (id, username, month, year, bytes, quota_in_mb) VALUES (NULL, %s, %s, %s, %s, %s)", \

(username, month, year, info[0], info[1]))

我仍然有兴趣知道更新(第一个实现)有什么问题。我现在就这样把剧本留下。非常感谢你。在