mysql 数据重复总数

CREATE UNIQUE INDEX idx_unique_column ON table_name (column_name);

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

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

# 示例代码，使用Python和MySQL Connector
import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="database_name")
cursor = db.cursor()

# 检查数据是否存在
cursor.execute("SELECT * FROM table_name WHERE column_name = 'value'")
result = cursor.fetchone()

if not result:
    # 插入数据
    cursor.execute("INSERT INTO table_name (column_name) VALUES ('value')")
    db.commit()

DELETE t1 FROM table_name t1 INNER JOIN table_name t2 
WHERE t1.id > t2.id AND t1.column_name = t2.column_name;