将Python列表转换为SQL列

import mysql.connector

# 创建数据库连接
conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# 获取游标对象
cursor = conn.cursor()

# 创建表
create_table_query = """
CREATE TABLE IF NOT EXISTS my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    value VARCHAR(255)
)
"""
cursor.execute(create_table_query)

# Python列表
my_list = ['item1', 'item2', 'item3']

# 将列表元素插入表中
insert_query = "INSERT INTO my_table (value) VALUES (%s)"
for item in my_list:
    cursor.execute(insert_query, (item,))

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()