如何将列表列表插入到表中？[Python]

my_list = [1, 2, 3, 4, 5]
sql = "INSERT INTO my_table (value) VALUES (%s)"

for item in my_list:
    cursor.execute(sql, (item,))

connection.commit()

import pymysql

# 连接到数据库
connection = pymysql.connect(host='localhost', user='username', password='password', database='my_database')
cursor = connection.cursor()

# 创建SQL语句
my_list = [1, 2, 3, 4, 5]
sql = "INSERT INTO my_table (value) VALUES (%s)"

# 执行SQL语句
for item in my_list:
    cursor.execute(sql, (item,))

# 提交事务
connection.commit()

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