将Python字典编写为每个键具有多个值的MySQL

data = {
    'key1': ['value1', 'value2', 'value3'],
    'key2': ['value4', 'value5'],
    'key3': ['value6']
}

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

for key, values in data.items():
    for value in values:
        # 构建插入语句
        insert_query = "INSERT INTO your_table (key_column, value_column) VALUES (%s, %s)"
        insert_values = (key, value)
        
        # 执行插入语句
        cursor.execute(insert_query, insert_values)

cnx.commit()
cursor.close()
cnx.close()