duplicate keys detected: '0'. this may cause an update error.

-- 假设表名为 `my_table`，主键为 `id`
SELECT id, COUNT(*)
FROM my_table
GROUP BY id
HAVING COUNT(*) > 1;

DELETE FROM my_table
WHERE id IN (
    SELECT id
    FROM (
        SELECT id
        FROM my_table
        GROUP BY id
        HAVING COUNT(*) > 1
    ) AS duplicates
);

BEGIN TRANSACTION;

-- 锁定要更新的记录
SELECT * FROM my_table WHERE id = '0' FOR UPDATE;

-- 执行更新操作
UPDATE my_table SET column_name = 'new_value' WHERE id = '0';

COMMIT;

import pandas as pd

# 假设数据存储在CSV文件中
data = pd.read_csv('data.csv')

# 删除重复的主键值
data.drop_duplicates(subset=['id'], inplace=True)

# 将清理后的数据导入数据库
data.to_sql('my_table', engine, if_exists='append', index=False)

ALTER TABLE my_table ADD CONSTRAINT pk_my_table PRIMARY KEY (id);