mysql 查询绑定变量值

-- 创建一个示例表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

-- 插入一些示例数据
INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO users (id, name, email) VALUES (2, 'Bob', 'bob@example.com');

-- 使用绑定变量执行查询
SET @id = 1;
SELECT * FROM users WHERE id = ?;

import mysql.connector

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

# 创建游标
cursor = db.cursor(prepared=True)

# 定义SQL语句和绑定变量
sql = "SELECT * FROM users WHERE id = %s"
id_value = (1,)

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

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

# 打印结果
for row in result:
    print(row)

# 关闭游标和连接
cursor.close()
db.close()