如何追加共享相同唯一标识符的重复记录？

import pymysql

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

# 创建插入语句
sql = "INSERT INTO mytable (id, name) VALUES (%s, %s)"
data = [(1, 'John'), (2, 'Jane'), (1, 'Mike')]  # 重复的记录

try:
    # 执行插入语句
    cursor.executemany(sql, data)
    conn.commit()
    print("插入成功")
except pymysql.Error as e:
    # 处理错误情况
    if e.args[0] == 1062:  # 唯一键冲突
        # 执行更新操作
        update_sql = "UPDATE mytable SET name = %s WHERE id = %s"
        for record in data:
            cursor.execute(update_sql, (record[1], record[0]))
        conn.commit()
        print("更新成功")
    else:
        print("插入失败：", e)
finally:
    # 关闭数据库连接
    cursor.close()
    conn.close()