擅长:python、mysql、java
<pre><code>import sqlite3
import numpy
conn = sqlite3.connect('lotto.db')
cur = conn.cursor()
def fun(a,b,c,d,e,f):
list = [a, b, c ,d, e, f]
print(list)
return numpy.mean(list)
numbers = cur.execute("SELECT * FROM combinations6")
num = numbers.fetchall()
for row in num:
cur.execute("UPDATE combinations6 SET average = ? WHERE id = ?", (fun(row[0],row[1],row[2],row[3],row[4],row[5]), row[7]))
conn.commit()
conn.close()
</code></pre>
<p>奇怪地修复了添加到查询并使用不同的指针和不同的查询</p>
^{pr2}$
<p>谢谢你的帮助,把我带到那里:)</p>