mysql 插入list到

import mysql.connector

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

cursor = db.cursor()

# 假设你的表名为 `your_table`，并且有 `column1`, `column2`, `column3` 这些列
data_list = [
    {'column1': 'value1', 'column2': 'value2', 'column3': 'value3'},
    {'column1': 'value4', 'column2': 'value5', 'column3': 'value6'},
    # 更多数据...
]

# 构建批量插入的SQL语句
sql = "INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)"
values = [(d['column1'], d['column2'], d['column3']) for d in data_list]

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

# 提交事务
db.commit()

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