擅长:python、mysql、java
<p>谢谢@Martijn Pieters,我需要使用rowid。这就是让它为我工作的代码:</p>
<pre><code>c.execute("SELECT rowid, framenum FROM learnAlg")
db_framenum = c.fetchall()
print(db_framenum)
# How much v6 framenum differentiates from v4
change_fn = 0
for e, f in enumerate(db_framenum):
e += 1
db_framenum_new = f[1]
if db_framenum_new in change_numbers:
change_fn += 1
db_framenum_new = db_framenum_new + change_fn
c.execute("UPDATE learnAlg SET framenum=? WHERE rowid=?",
(db_framenum_new, e))
</code></pre>
<p>但是我仍然不知道如何正确地使用c.executemany()。有关更新的问题,请参阅编辑。在</p>