python操作mysql数据库

#!/usr/bin/env python
# coding=utf-8
import MySQLdb
import csv
conn=MySQLdb.connect(host="192.168.6.63",user="test",passwd="test",db="mergedata01")
cur=conn.cursor()
#select * from history where history.version_date >=STR_TO_DATE('2016.04.01','%Y.%m.%d') and history.version_date<=STR_TO_DATE('2016.07.01','%Y.%m.%d') order by RAND() LIMIT 0,100;
data=cur.execute("select * from history where version_date like '2016.06%' limit 20000;")
info=cur.fetchmany(data)
with open('data.csv','a') as wp:
    for i in info:
        print i
        raw=csv.writer(wp,dialect='excel')
        raw.writerow(i)
data1=cur.execute("select * from history where version_date like '2016.07%' limit 20000;")
info1=cur.fetchmany(data1)
with open('data.csv','a') as wp:
    for i in info1:
        print i
        raw=csv.writer(wp,dialect='excel')
        raw.writerow(i)
#data2=cur.execute("select * from history where version_date like '2016.04%' limit 20000;")
#info2=cur.fetchmany(data2)
#with open('data.csv','a') as wp:
#    for i in info2:
#        print i
#        raw=csv.writer(wp,dialect='excel')
#        raw.writerow(i)
#data3=cur.execute("select * from history where version_date like '2016.05%' limit 20000;")
#info3=cur.fetchmany(data3)
#with open('data.csv','a') as wp:
#    for i in info3:
#        print i
#        raw=csv.writer(wp,dialect='excel')
#        raw.writerow(i)
cur.close()
conn.commit()
conn.close()
print 'data:',data