阅读背景:

如何在不将格式化为列表的情况下将sqlite导出到Python中的CSV?

来源:互联网 

Here is what I currently have:

这是我目前拥有的:

conn = sqlite3.connect(dbfile)
conn.text_factory = str ## my current (failed) attempt to resolve this
cur = conn.cursor()
data = cur.execute("SELECT * FROM mytable")

f = open('output.csv', 'w')
print >> f, "Column1, Column2, Column3, Etc."
for row in data:
  print >> f, row
f.close()
co



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: