python创建一个csv文件,如何在Python中从数据库创建CSV文件？

I have a Sqlite 3 and/or MySQL table named "clients"..

Using python 2.6, How do I create a csv file named Clients100914.csv with headers?

excel dialect...

The Sql execute: select * only gives table data, but I would like complete table with headers.

How do I create a record set to get table headers. The table headers should come directly from sql not written in python.

w = csv.writer(open(Fn,'wb'),dialect='excel')

#w.writelines("header_row")

#Fetch into sqld

w.writerows(sqld)

This code leaves me with file open and no headers. Also cant get figure out how to use file as log.

解决方案import csv

import sqlite3

from glob import glob; from os.path import expanduser

conn = sqlite3.connect( # open "places.sqlite" from one of the Firefox profiles