파이썬으로 SQLite db파일을 csv로 export
import sqlite3, os conn = sqlite3.connect('example.db')c = conn.cursor() com_te="" for row in c.execute('SELECT * FROM de_addr order by id desc'): for m in range(1,9):com_te = com_te + str(row[m])+","com_te=com_te+"\n" f=open("addr.csv","w")f.write(com_te)f.close c.close() print("CSV file export done.")
카테고리 없음
2016. 11. 23. 19:18