mysql数据库循环保存数据

-- 批量插入示例
INSERT INTO table_name (column1, column2, column3)
VALUES
    (value1, value2, value3),
    (value4, value5, value6),
    ...
    (valueN-2, valueN-1, valueN);

-- INSERT IGNORE示例
INSERT IGNORE INTO table_name (column1, column2, column3)
VALUES
    (value1, value2, value3),
    (value4, value5, value6),
    ...
    (valueN-2, valueN-1, valueN);

-- REPLACE INTO示例
REPLACE INTO table_name (column1, column2, column3)
VALUES
    (value1, value2, value3),
    (value4, value5, value6),
    ...
    (valueN-2, valueN-1, valueN);

# 分批次插入数据示例
batch_size = 1000
data = [...]  # 假设data是一个包含大量数据的列表

for i in range(0, len(data), batch_size):
    batch = data[i:i + batch_size]
    # 执行批量插入操作
    cursor.executemany("INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)", batch)