如何从两个不同的数据库检查productid (比较两个列表并返回不匹配的项进行添加)

import mysql.connector

# 连接数据库1
db1 = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database1"
)

# 连接数据库2
db2 = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database2"
)

# 获取数据库1中的productid数据
cursor1 = db1.cursor()
cursor1.execute("SELECT productid FROM table1")
result1 = cursor1.fetchall()
list1 = [row[0] for row in result1]

# 获取数据库2中的productid数据
cursor2 = db2.cursor()
cursor2.execute("SELECT productid FROM table2")
result2 = cursor2.fetchall()
list2 = [row[0] for row in result2]

# 比较两个列表并返回不匹配的项
unmatched_items = []
for item in list1:
    if item not in list2:
        unmatched_items.append(item)

# 添加不匹配的项到数据库2
cursor2 = db2.cursor()
for item in unmatched_items:
    cursor2.execute("INSERT INTO table2 (productid) VALUES (%s)", (item,))
db2.commit()

# 关闭数据库连接
cursor1.close()
cursor2.close()
db1.close()
db2.close()