使用pymysql在MySQL中插入包含多个值的列表

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydb')
cursor = conn.cursor()

# 定义插入语句
sql = "INSERT INTO mytable (column1, column2) VALUES (%s, %s)"

# 定义要插入的数据列表
data = [
    ('value1', 'value2'),
    ('value3', 'value4'),
    ('value5', 'value6')
]

try:
    # 执行批量插入
    cursor.executemany(sql, data)
    # 提交事务
    conn.commit()
    print("插入成功")
except Exception as e:
    # 发生错误时回滚
    conn.rollback()
    print("插入失败：", str(e))

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