mysql中怎么连续插入数据

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');

INSERT INTO users (name, email) VALUES
('Bob', 'bob@example.com'),
('Charlie', 'charlie@example.com'),
('David', 'david@example.com');

import mysql.connector

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

cursor = db.cursor()

# 构建批量插入的SQL语句
sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
val = [
    ('Eve', 'eve@example.com'),
    ('Frank', 'frank@example.com'),
    ('Grace', 'grace@example.com'),
    # 更多数据...
]

# 执行批量插入
cursor.executemany(sql, val)

# 提交事务
db.commit()

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

INSERT IGNORE INTO users (name, email) VALUES ('Alice', 'alice@example.com');