运用Python从一个数据库的某个表中导数据到另一个数据库的某个表-蒲公英云

运用Python从一个数据库的某个表中导数据到另一个数据库的某个表

亦凉 2022-06-03 05:08 386阅读 0赞

之前写过一篇通过Node.js从一个数据库的某个表中导数据到另一个数据库的某个表，现在是通过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) " \
                       " VALUES ('%s', '%s', '%s', '%s', '%s' )" %\
                       (value[0], value[1], value[2], value[3], value[4])
            print(writeSql)
            try:
                Wcursor.execute(writeSql)
                write.commit()
            except:
                write.rollback()
            write.close()
        read.close()
if __name__ == '__main__':
    readAndWrite()