mysql用动态sql

import mysql.connector

def dynamic_sql_example(condition):
    conn = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    cursor = conn.cursor()

    if condition == "active":
        query = "SELECT * FROM users WHERE status = 'active'"
    elif condition == "inactive":
        query = "SELECT * FROM users WHERE status = 'inactive'"
    else:
        query = "SELECT * FROM users"

    cursor.execute(query)
    result = cursor.fetchall()

    for row in result:
        print(row)

    cursor.close()
    conn.close()

# 调用示例
dynamic_sql_example("active")

query = "SELECT * FROM users WHERE status = %s"
cursor.execute(query, (condition,))