python 操作mysql数据库

来源：互联网发布：淘宝美工可以自学吗编辑：程序博客网时间：2024/04/30 02:19

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])

0 0