mysql中动态语句

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 动态生成SQL语句
sql = "SELECT * FROM users WHERE age > %s"
age = 25

# 执行查询
cursor.execute(sql, (age,))

# 获取结果
results = cursor.fetchall()

for row in results:
    print(row)

# 关闭连接
cursor.close()
db.close()

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 动态生成SQL语句（不安全）
age = 25
sql = "SELECT * FROM users WHERE age > " + str(age)

# 执行查询
cursor.execute(sql)

# 获取结果
results = cursor.fetchall()

for row in results:
    print(row)

# 关闭连接
cursor.close()
db.close()

sql = "SELECT * FROM users WHERE age > %s"
cursor.execute(sql, (user_input,))

CREATE INDEX idx_age ON users(age);