错误1062 (23000)：键'PRIMARY‘的条目'DP1’重复

-- 查找重复的主键值
SELECT PRIMARY_KEY_COLUMN, COUNT(*)
FROM your_table
GROUP BY PRIMARY_KEY_COLUMN
HAVING COUNT(*) > 1;

-- 删除重复的记录（保留一条）
DELETE t1 FROM your_table t1
JOIN your_table t2 
WHERE t1.PRIMARY_KEY_COLUMN = t2.PRIMARY_KEY_COLUMN AND t1.id > t2.id;

-- 使用 INSERT IGNORE 忽略重复的插入
INSERT IGNORE INTO your_table (PRIMARY_KEY_COLUMN, other_columns) VALUES ('DP1', 'value');

-- 使用 ON DUPLICATE KEY UPDATE 更新已存在的记录
INSERT INTO your_table (PRIMARY_KEY_COLUMN, other_columns) 
VALUES ('DP1', 'value')
ON DUPLICATE KEY UPDATE other_columns = 'value';

# 示例代码（Python）
import mysql.connector

def insert_data(primary_key_value, other_values):
    conn = mysql.connector.connect(user='your_user', password='your_password', host='your_host', database='your_database')
    cursor = conn.cursor()
    
    # 检查主键是否存在
    cursor.execute("SELECT PRIMARY_KEY_COLUMN FROM your_table WHERE PRIMARY_KEY_COLUMN = %s", (primary_key_value,))
    if cursor.fetchone() is None:
        cursor.execute("INSERT INTO your_table (PRIMARY_KEY_COLUMN, other_columns) VALUES (%s, %s)", (primary_key_value, other_values))
        conn.commit()
    else:
        print("Duplicate entry for primary key.")
    
    cursor.close()
    conn.close()