当我们通过for循环提供输入字段时，如何填充数据库表？

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')

# 创建一个新的表
cursor = cnx.cursor()
create_table_query = '''
    CREATE TABLE IF NOT EXISTS my_table (
        id INT AUTO_INCREMENT PRIMARY KEY,
        field1 VARCHAR(255),
        field2 INT
    )
'''
cursor.execute(create_table_query)

# 提供输入字段的列表
input_fields = [
    {'field1': 'value1', 'field2': 1},
    {'field1': 'value2', 'field2': 2},
    {'field1': 'value3', 'field2': 3}
]

# 循环插入数据
for input_field in input_fields:
    insert_query = '''
        INSERT INTO my_table (field1, field2)
        VALUES (%s, %s)
    '''
    insert_values = (input_field['field1'], input_field['field2'])
    cursor.execute(insert_query, insert_values)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()