将多个列表从python读取到SQL查询中

import pandas as pd
import pymysql

list1 = pd.read_csv('list1.csv')
list2 = pd.read_csv('list2.csv')
list3 = pd.read_csv('list3.csv')

conn = pymysql.connect(host='数据库主机地址', user='用户名', password='密码', database='数据库名')

cursor = conn.cursor()

# 假设数据库表名为list_data，包含三个字段：column1、column2、column3
for index, row in list1.iterrows():
    cursor.execute("INSERT INTO list_data (column1, column2, column3) VALUES (%s, %s, %s)", (row['column1'], row['column2'], row['column3']))

for index, row in list2.iterrows():
    cursor.execute("INSERT INTO list_data (column1, column2, column3) VALUES (%s, %s, %s)", (row['column1'], row['column2'], row['column3']))

for index, row in list3.iterrows():
    cursor.execute("INSERT INTO list_data (column1, column2, column3) VALUES (%s, %s, %s)", (row['column1'], row['column2'], row['column3']))

conn.commit()
cursor.close()
conn.close()