从SQL db和update否则插入一行中检测到2个重复值(使用python)

import mysql.connector

# 连接到数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 定义要插入的数据
data = {'column1': 'value1', 'column2': 'value2', 'column3': 'value3'}

# 构建SQL查询语句
query = "SELECT COUNT(*) FROM your_table WHERE column1 = %(column1)s AND column2 = %(column2)s"

# 执行查询
cursor.execute(query, data)
result = cursor.fetchone()

# 检查是否存在重复值
if result[0] > 0:
    # 如果存在重复值，则执行更新操作
    update_query = "UPDATE your_table SET column3 = %(column3)s WHERE column1 = %(column1)s AND column2 = %(column2)s"
    cursor.execute(update_query, data)
    cnx.commit()
    print("更新成功！")
else:
    # 如果不存在重复值，则执行插入操作
    insert_query = "INSERT INTO your_table (column1, column2, column3) VALUES (%(column1)s, %(column2)s, %(column3)s)"
    cursor.execute(insert_query, data)
    cnx.commit()
    print("插入成功！")

# 关闭数据库连接
cursor.close()
cnx.close()