python操作mysql数据库
来源:互联网 发布:java快速入门的书籍 编辑:程序博客网 时间:2024/05/03 01:56
#!/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
# 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
0 0
- Python操作Mysql数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python 操作mysql 数据库
- python操作mysql数据库
- python 操作 mysql数据库
- python操作MySQL数据库
- python操作MySQL数据库
- Python操作MySQL数据库
- Python操作mysql数据库
- python操作MySQL数据库
- C++ Primer 第14章 知识点回顾
- Eclipse保存时自动格式化代码
- POJ 1363 Rails
- 在linux下用tomcat部署java web项目的过程与注意事项
- Fragment延迟加载
- python操作mysql数据库
- python datetime模块(1) 时间格式化
- Theano Tutorial文档翻译(二):代数
- Linux环境变量设置
- Scala(4)
- hdu5816 多校7 Hearthstone【组合计数+dp】
- SVM
- 《入门经典》0
- LCD窗口重叠透明度和色度键解决办法