将 sql 数据导出为 csv 文件

gistfile1.py

# -*- coding: utf-8 -*-
# http://stackoverflow.com/questions/3710263/how-do-i-create-a-csv-file-from-database-in-python
# 如遇编码错误，可使用python3

import csv
import sqlite3

conn = sqlite3.connect("pcd.db")
cursor = conn.cursor()
cursor.execute("select * from domain_data;")

csv_writer = csv.writer(open("out.csv", "wt"))
csv_writer.writerow([i[0] for i in cursor.description]) # write headers
csv_writer.writerows(cursor)
del csv_writer # this will close the CSV file