python查询数据库并导处csv文件

# -*- coding: utf-8 -*-import MySQLdbimport mathimport csvimport codecsimport sysreload(sys)sys.setdefaultencoding('utf-8')csvfile = open('sample.csv', 'wb')csvfile.write(codecs.BOM_UTF8)     # 防止中文乱码！！！writer = csv.writer(csvfile,dialect='excel')#开始写第一行  数组的形式writer.writerow(['id', 'entry', 'type'])try:    connect = MySQLdb.connect(host='localhost', user='root', passwd='', db='test', charset='utf8')    db = connect.cursor()    db.execute("select * from words where annotator="+"'"+annotator+"'") #忽略查询语句    data=db.fetchall()    #写入多行格式    '''    data=[       (1,2,3),       (4,5,6),       (7,8,9)    ]    '''    writer.writerows(data)    writer.writerows([(),(),()]) #三个空白行    csvfile.close()    connect.commit()    db.close()    connect.close()    print "Done!"except MySQLdb.Error,e:    print "MySQL Error %d:%s"%(e.args[0],e.args[1])

读csv文件代码：

# -*- coding: utf-8 -*-import csvimport sysreload(sys)sys.setdefaultencoding('utf-8')csv_reader = csv.reader(open('test.csv', 'rb'))for row in csv_reader:    data={}    #自己根据打印出来的数据操作~~