mysql 批量写入表

INSERT INTO table_name (column1, column2, ...)
VALUES
    (value1, value2, ...),
    (value3, value4, ...),
    ...
    (valueN, valueM, ...);

INSERT INTO table_name (column1, column2, ...)
SELECT column1, column2, ...
FROM another_table
WHERE condition;

-- 使用 INSERT IGNORE 忽略主键冲突
INSERT IGNORE INTO table_name (column1, column2, ...)
VALUES
    (value1, value2, ...),
    (value3, value4, ...),
    ...
    (valueN, valueM, ...);

-- 使用 REPLACE INTO 替换主键冲突的记录
REPLACE INTO table_name (column1, column2, ...)
VALUES
    (value1, value2, ...),
    (value3, value4, ...),
    ...
    (valueN, valueM, ...);

import mysql.connector

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

cursor = db.cursor()

# 批量插入数据
sql = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
val = [
    ('value1', 'value2'),
    ('value3', 'value4'),
    ('value5', 'value6')
]

cursor.executemany(sql, val)

# 提交事务
db.commit()

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