mysql 有重复数据

ALTER TABLE table_name ADD UNIQUE (column_name);

ALTER TABLE table_name ADD PRIMARY KEY (column_name);

INSERT IGNORE INTO table_name (column1, column2) VALUES ('value1', 'value2');

REPLACE INTO table_name (column1, column2) VALUES ('value1', 'value2');

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

def insert_data(cursor, table_name, data):
    query = f"SELECT * FROM {table_name} WHERE column_name = %s"
    cursor.execute(query, (data['value'],))
    result = cursor.fetchone()
    if not result:
        insert_query = f"INSERT INTO {table_name} (column_name) VALUES (%s)"
        cursor.execute(insert_query, (data['value'],))
        cursor.connection.commit()

# 连接数据库并插入数据
db = mysql.connector.connect(host="localhost", user="user", password="password", database="database")
cursor = db.cursor()
data = {'value': 'unique_value'}
insert_data(cursor, 'table_name', data)

CREATE TEMPORARY TABLE temp_table AS SELECT DISTINCT * FROM original_table;
DROP TABLE original_table;
ALTER TABLE temp_table RENAME TO original_table;