python操作数据库
来源:互联网 发布:淘宝上冷门的好东西 编辑:程序博客网 时间:2024/05/16 02:38
import MySQLdb
try:
conn_remote = MySQLdb.connect(host='10.220.156.34',user='dc_user',passwd='dc_user',db='SZWG_ECOMON',port=3306)
#conn_local = MySQLdb.connect(host='10.46.190.21', user='mysql', passwd='mhxzkhl',db='test', port=3306)
conn_local = MySQLdb.connect(host='localhost', user='mysql', passwd='mhxzkhl',db='test', port=3306)
cur_remote = conn_remote.cursor()
cur_local = conn_local.cursor()
# cur_remote.execute('select * from job_info where user=\'dt-udw-etl\' limit 10')
# cur_remote.execute('select * from job_info where user=\'dt-udw-insight\' limit 10')
cur_remote.execute('select * from job_info limit 3422873')
results = cur_remote.fetchall();
for row in results:
for i in row:
print str(i)+" ",
print
values = []
for row in results:
values = []
for i in range(18):
values.append(str(row[i]))
job_name = str(row[1])
values.append(job_name[0:job_name.find('_2013')])
#print"++++++++++++++++++++"+str(job_name[0:job_name.find('_2013')])
#print "values-------------------------------"+str(values)
cur_local.execute('insert into job_info_new values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',values)
#print "invinsible seperator line-----------------------------------"
cur_local.execute('select * from job_info limit 10')
results_2 = cur_local.fetchall()
for row in results_2:
print row
conn_local.commit()
cur_remote.close()
conn_remote.close()
cur_local.close()
conn_local.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
try:
conn_remote = MySQLdb.connect(host='10.220.156.34',user='dc_user',passwd='dc_user',db='SZWG_ECOMON',port=3306)
#conn_local = MySQLdb.connect(host='10.46.190.21', user='mysql', passwd='mhxzkhl',db='test', port=3306)
conn_local = MySQLdb.connect(host='localhost', user='mysql', passwd='mhxzkhl',db='test', port=3306)
cur_remote = conn_remote.cursor()
cur_local = conn_local.cursor()
# cur_remote.execute('select * from job_info where user=\'dt-udw-etl\' limit 10')
# cur_remote.execute('select * from job_info where user=\'dt-udw-insight\' limit 10')
cur_remote.execute('select * from job_info limit 3422873')
results = cur_remote.fetchall();
for row in results:
for i in row:
print str(i)+" ",
values = []
for row in results:
values = []
for i in range(18):
values.append(str(row[i]))
job_name = str(row[1])
values.append(job_name[0:job_name.find('_2013')])
#print"++++++++++++++++++++"+str(job_name[0:job_name.find('_2013')])
#print "values-------------------------------"+str(values)
cur_local.execute('insert into job_info_new values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',values)
#print "invinsible seperator line-----------------------------------"
cur_local.execute('select * from job_info limit 10')
results_2 = cur_local.fetchall()
for row in results_2:
print row
conn_local.commit()
cur_remote.close()
conn_remote.close()
cur_local.close()
conn_local.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
0 0
- Python操作Mysql数据库
- python的数据库操作
- python操作数据库
- python SQlite数据库操作
- python操作MySQL数据库
- python操作MySQL数据库
- python操作数据库
- Python 数据库操作
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- Python 操作Oralce数据库
- python操作MySQL数据库
- python数据库操作
- Python操作Oracle数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- S2SH集成maven配置
- java回顾-servlet
- Eclipse调试快捷键整理
- UML类图几种关系的总结
- Android-activity的四种启动模式
- python操作数据库
- 三大WEB服务器对比分析(apache ,lighttpd,nginx)
- 当DOTA2天梯越过3700分的时候
- 给你的Android模拟器提提速
- [MVC]站点的一些特殊问题总结
- 值传递、指针传递、引用传递的总结
- 简单编程 (二十六)窗体的创建
- JavaScript MVC 框架开源软件
- 一来就给LeetCode跪了