mysql in的正确使用

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

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

-- 使用 JOIN
SELECT u.*
FROM users u
JOIN (SELECT 1 AS id UNION ALL SELECT 3 UNION ALL SELECT 5) ids ON u.id = ids.id;

-- 使用子查询
SELECT *
FROM users
WHERE id IN (SELECT id FROM (SELECT 1 AS id UNION ALL SELECT 3 UNION ALL SELECT 5) AS subquery);

-- 错误示例
SELECT * FROM users WHERE id IN ('1', '3', '5'); -- id 字段是整数类型

-- 正确示例
SELECT * FROM users WHERE id IN (1, 3, 5);

-- 分批次查询
SELECT * FROM users WHERE id IN (1, 2, 3);
SELECT * FROM users WHERE id IN (4, 5, 6);
...

-- 使用临时表
CREATE TEMPORARY TABLE temp_ids (id INT);
INSERT INTO temp_ids (id) VALUES (1), (3), (5);
SELECT * FROM users WHERE id IN (SELECT id FROM temp_ids);
DROP TEMPORARY TABLE temp_ids;