生成变量的所有组合并插入到临时表中

import itertools

# 定义变量和取值范围
variables = {
    'A': [1, 2],
    'B': ['a', 'b', 'c'],
    'C': ['X', 'Y']
}

# 生成所有组合
combinations = list(itertools.product(*variables.values()))

# 打印所有组合
for combination in combinations:
    print(combination)

import mysql.connector

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

# 创建临时表
create_table_query = "CREATE TABLE temp_table (id INT AUTO_INCREMENT PRIMARY KEY, combination VARCHAR(255))"
cursor.execute(create_table_query)

# 插入组合数据
insert_query = "INSERT INTO temp_table (combination) VALUES (%s)"
for combination in combinations:
    cursor.execute(insert_query, (str(combination),))

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()