如何从变量数组生成准备好的MySQL查询？

import mysql.connector

def generate_query(variables):
    query = "SELECT * FROM table_name WHERE "
    conditions = []

    for key, value in variables.items():
        conditions.append(f"{key} = '{value}'")

    query += " AND ".join(conditions)
    return query

# 示例变量数组
variables = {
    "column1": "value1",
    "column2": "value2"
}

query = generate_query(variables)

# 执行查询
connection = mysql.connector.connect(
    host="your_host",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = connection.cursor()
cursor.execute(query)

# 获取查询结果
result = cursor.fetchall()

import mysql.connector

def generate_query(variables):
    query = "SELECT * FROM table_name WHERE "
    conditions = []

    for key, value in variables.items():
        conditions.append(f"{key} = %s")

    query += " AND ".join(conditions)
    return query

# 示例变量数组
variables = {
    "column1": "value1",
    "column2": "value2"
}

query = generate_query(variables)

# 执行查询
connection = mysql.connector.connect(
    host="your_host",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = connection.cursor()
cursor.execute(query, tuple(variables.values()))

# 获取查询结果
result = cursor.fetchall()