mysql in失效

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

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago');

SELECT * FROM users WHERE city IN (SELECT city FROM cities WHERE population > 1000000);

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago');

CREATE INDEX idx_city ON users(city);

CREATE TEMPORARY TABLE temp_cities AS SELECT city FROM cities WHERE population > 1000000;
SELECT * FROM users WHERE city IN (SELECT city FROM temp_cities);

-- 创建示例表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    city VARCHAR(100)
);

-- 插入示例数据
INSERT INTO users (id, name, city) VALUES
(1, 'Alice', 'New York'),
(2, 'Bob', 'Los Angeles'),
(3, 'Charlie', 'Chicago'),
(4, 'David', 'Houston');

-- 查询来自特定城市的用户
SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago');