mysql参数化查询 in

SELECT * FROM users WHERE id IN (1, 2, 3, 4);

import mysql.connector

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

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

# 定义用户ID列表
user_ids = [1, 2, 3, 4]

# 使用IN子句进行参数化查询
query = "SELECT * FROM users WHERE id IN %s"
cursor.execute(query, (tuple(user_ids),))

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

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

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

query = "SELECT * FROM users WHERE id IN %s"
cursor.execute(query, (tuple(user_ids),))

CREATE TEMPORARY TABLE temp_ids (id INT);
INSERT INTO temp_ids (id) VALUES (1), (2), (3), (4);
SELECT * FROM users JOIN temp_ids ON users.id = temp_ids.id;
DROP TEMPORARY TABLE temp_ids;