python - 为什么这个sql脚本不执行？

Question

嗨，我有以下 python:

c = conn.cursor()

#get the account id for the specific user

actidSQL = "select id from accounts where user_id = (select id from auth_user where username = '%s');" % user
c.execute(actidSQL)
actid = c.fetchone()[0]
print actid

#fill the latencies table - currently not firing, not sure why?
latencies_sql = "insert into latencies(account, replier, sender, replyemail, origemail, replydate, origdate) select m1.account, c1.id as replier, c2.id as sender, m1.id as replyemail, m2.id as origemail, m1.date as replydate, m2.date as origdate from contacts c1, contacts c2, emails m1, emails m2 where m1.id > m2.id and m1.reply = m2.mid and m1.reply is not null and c1.id = m1.fr and c2.id = m2.fr and m1.account = %s and m1.account = m2.account;" % (actid)
print latencies_sql
c.execute(latencies_sql)

第一个 sql 执行，但第二个 sql 不执行。有什么原因吗？

Answer 1

“第一个 sql 执行但第二个 sql 不执行。”是什么意思？你得到一个错误吗？或者数据库中没有数据？我假设数据库中没有数据并且您使用的是MySQL。这是因为您没有提交更改。脚本末尾的 conn.commit() 应该会有所帮助。