mysql中not in使用方法

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

SELECT column_name(s)
FROM table_name
WHERE column_name NOT IN (SELECT column_name FROM another_table WHERE condition);

SELECT *
FROM employees
WHERE department_id NOT IN (1, 2, 3);

SELECT *
FROM employees
WHERE department_id NOT IN (SELECT department_id FROM departments WHERE location = 'New York');

SELECT *
FROM employees e
WHERE NOT EXISTS (SELECT 1 FROM departments d WHERE d.department_id = e.department_id AND d.location = 'New York');

SELECT *
FROM employees
WHERE department_id NOT IN (SELECT department_id FROM departments WHERE location = 'New York' AND department_id IS NOT NULL);