擅长:python、mysql、java
<p>您需要传递序列(<code>[[cont,id], [cont,id], [cont,id], ...]</code>,而不是<code>[cont, cont, cont, ...], [id, id, id, ..]</code>):</p>
<pre><code>for path in paths:
params = []
for data in some_computation(path):
if len(data_ids) >= CHUNKSIZE:
c.executemany("UPDATE TABLENAME SET cont=? WHERE id=?", params)
cnx.commit()
params = []
params.append([data[1], data[0]])
if params:
c.executemany("UPDATE TABLENAME SET cont=? WHERE id=?", params)
cnx.commit()
</code></pre>