避免循环,运行一个
INSERT INTO ... SELECT
查询。现在,您在循环内外重用同一个游标,这会导致处理问题。使用两个不同的游标或有效地组合并让数据库引擎运行操作查询:
sql = '''INSERT INTO Counts (org, [count])
SELECT SUBSTR(email, INSTR(email, '@')+1) AS org,
SUM(count) as [count]
FROM Em
GROUP BY org
ORDER BY count DESC
'''
cur.execute(sql)
conn.commit()