将原始元组保存到数据库中

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    age INT,
    email VARCHAR(100)
);

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 原始元组列表
users_data = [
    ("Alice", 30, "alice@example.com"),
    ("Bob", 25, "bob@example.com"),
    ("Charlie", 35, "charlie@example.com")
]

# 插入数据
for user in users_data:
    query = "INSERT INTO users (name, age, email) VALUES (%s, %s, %s)"
    cursor.execute(query, user)

# 提交事务
db.commit()

# 关闭连接
cursor.close()
db.close()

try:
    for user in users_data:
        query = "INSERT INTO users (name, age, email) VALUES (%s, %s, %s)"
        cursor.execute(query, user)
    db.commit()
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    db.close()

ALTER TABLE users ADD UNIQUE (email);

for user in users_data:
    query = "INSERT INTO users (name, age, email) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE name=name"
    cursor.execute(query, user)