python数据导入一个列表_python实现获取一个表数据插入另外一个库中的表

#!/usr/bin/env python

# _*_ conding:utf-8 _*_

import sys

import os

import time

import datetime

import MySQLdb

bb=datetime.datetime.now()

c_time=time.strftime("%Y%m%d",time.localtime(time.time()))

today=datetime.date.today()

oneday=datetime.timedelta(days=1)

yesterday=today-oneday

yes_last=datetime.datetime.strftime(yesterday,"%Y%m%d")

print yes_last

#print c_time

try:

conn1=MySQLdb.connect(host='192.168.1.17',user='dlan',passwd='root123',port=3306,db='chat')

conn2=MySQLdb.connect(host='192.168.1.17',user='dlan',passwd='root123',port=3306,db='test')

cur1 = conn1.cursor()

cur2 = conn2.cursor()

aa1='''select * from chat.honghong1_'''+yes_last

aa2 = "create table IF NOT EXISTS ip_limit_"+yes_last+" " +"(id int,name varchar(22),c_time datetime)"

cur1.execute(aa1)

bb=cur1.fetchall()

cur2.execute(aa2)

value=()

for i in xrange(len(bb)):

value=(bb[i])

db_insert="insert into"+' '+"ip_limit_"+yes_last +" "+ "values(%s,%s,%s)"

cur2.execute(db_insert,value)

print "OK"

conn2.commit()

print "--------"

conn1.commit()

cur1.close()

cur2.close()

conn1.close()

conn2.close()

except MySQLdb.Error,e:

print "Could not connect to MySQL server",e