如何在单个数据库列中插入动态添加的输入字段值？

dynamicFields = [
    {"name": "field1", "value": "value1"},
    {"name": "field2", "value": "value2"},
    {"name": "field3", "value": "value3"}
]

# 构建插入语句的SQL模板
sql_template = "INSERT INTO table_name ({}) VALUES ({})"

# 构建字段名和字段值的列表
field_names = []
field_values = []
for field in dynamicFields:
    field_names.append(field["name"])
    field_values.append(field["value"])

# 构建字段名的部分
field_names_str = ", ".join(field_names)

# 构建字段值的部分
field_values_str = ", ".join(["%s"] * len(field_values))

# 构建最终的SQL插入语句
sql_insert = sql_template.format(field_names_str, field_values_str)

import mysql.connector

# 建立数据库连接
conn = mysql.connector.connect(user='username', password='password', host='host', database='database_name')

# 创建游标
cursor = conn.cursor()

# 执行插入语句
cursor.execute(sql_insert, field_values)

# 提交事务
conn.commit()

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