创建具有唯一键的新对象

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL
);

try:
    cursor.execute("INSERT INTO users (username, email, password) VALUES (%s, %s, %s)", (username, email, password))
    connection.commit()
except IntegrityError as e:
    print(f"Error: {e}. Duplicate entry for username or email.")

CREATE TEMPORARY TABLE temp_users LIKE users;
ALTER TABLE temp_users DISABLE KEYS;
-- 批量插入数据到临时表
INSERT INTO temp_users (username, email, password) VALUES (...), (...), ...;
ALTER TABLE temp_users ENABLE KEYS;
-- 将数据从临时表转移到主表，自动处理唯一键冲突
INSERT IGNORE INTO users SELECT * FROM temp_users;
DROP TEMPORARY TABLE IF EXISTS temp_users;