mysql 动态执行sql

import mysql.connector

def dynamic_query(name):
    query = f"SELECT * FROM users WHERE name = '{name}'"
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    cursor.execute(query)
    result = cursor.fetchall()
    cursor.close()
    conn.close()
    return result

import mysql.connector

def dynamic_query(name):
    query = "SELECT * FROM users WHERE name = %s"
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    cursor.execute(query, (name,))
    result = cursor.fetchall()
    cursor.close()
    conn.close()
    return result

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