运用Python从一个数据库的某个表中导数据到另一个数据库的某个表
运用Python从一个数据库的某个表中导数据到另一个数据库的某个表
通过python来进行导数据,个人感觉操作起来还是比node.js方便不少,具体代码如下:
import pymysql
def readAndWrite():
for i in range(len(readDB)):
# 四个参数分别为数据库地址,用户名,密码,数据库名称
read = pymysql.connect("localhost", "root", "", "****")
Rcursor = read.cursor()
readSql = "SELECT id,phone,regist_time,login_lasttime,type FROM `user` WHERE DATE_FORMAT(login_lasttime,'%Y-%m-%d') = " + loginDate[i]
Rcursor.execute(readSql)
readResult = Rcursor.fetchall()
for value in readResult:
write = pymysql.connect("localhost", "root", "", "test")
Wcursor = write.cursor()
writeSql = "INSERT INTO userlogininfo(id,phone,regist_time,login_lasttime,type) " \