使用python将具有唯一约束的多行导入SQL表

import pymysql

# 建立与MySQL数据库的连接
conn = pymysql.connect(host='localhost', user='root', password='password', database='your_database')

# 创建游标对象
cursor = conn.cursor()

data = [
    ('John', 'Doe', 'john@example.com'),
    ('Jane', 'Smith', 'jane@example.com'),
    ('David', 'Johnson', 'david@example.com')
]

for row in data:
    try:
        # 构建插入SQL语句
        sql = "INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)"
        
        # 执行插入操作
        cursor.execute(sql, row)
        conn.commit()
    except Exception as e:
        # 忽略重复数据的插入错误
        if 'Duplicate entry' in str(e):
            pass
        else:
            print("Error:", str(e))

cursor.close()
conn.close()