mysql如何防止插入重复数据

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE,
    name VARCHAR(255) NOT NULL
);

import mysql.connector

try:
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    query = "INSERT INTO users (email, name) VALUES (%s, %s)"
    values = ("example@example.com", "John Doe")
    cursor.execute(query, values)
    conn.commit()
except mysql.connector.IntegrityError as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()

INSERT IGNORE INTO users (email, name) VALUES ("example@example.com", "John Doe");

INSERT INTO users (email, name) VALUES ("example@example.com", "John Doe")
ON DUPLICATE KEY UPDATE name = "John Doe";