擅长:python、mysql、java
<p>如果您的表有一些唯一的ID,请获取它们的排序列表(它们的实际值无关紧要,只关心它们的顺序):</p>
<pre><code>ids = [row[0] for row in cur.execute("SELECT id FROM MyTable ORDER BY id")]
iCount = 0
for id in ids:
iCount += 2
cur.execute("UPDATE MyTable SET WorkingID = ? WHERE id = ?",
[iCount, id])
</code></pre>
<p>如果没有这样的列,请改用<code>rowid</code>。在</p>