Python关联的MySQL中in的所有用法

1. 基本用法

在MySQL中，使用IN关键字可以匹配多个值，基本语法如下：

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

示例：

SELECT *
FROM employees
WHERE department IN ('Sales', 'Marketing');

2. 子查询

IN也可以与子查询一起使用，基本语法如下：

SELECT column1, column2, ...
FROM table_name
WHERE column_name IN (SELECT column_name FROM table_name WHERE condition);

示例：

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

3. BETWEEN

IN也可以与BETWEEN关键字一起使用，基本语法如下：

SELECT column1, column2, ...
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

示例：

SELECT *
FROM employees
WHERE salary BETWEEN 50000 AND 80000;

可以使用IN关键字来替代BETWEEN关键字，如下：

SELECT *
FROM employees
WHERE salary IN (50000, 60000, 70000, 80000);

4. NOT IN

除了匹配多个值，IN关键字还可以与NOT关键字一起使用，实现匹配不在指定值范围内的数据，基本语法如下：

SELECT column1, column2, ...
FROM table_name
WHERE column_name NOT IN (value1, value2, ...);

示例：

SELECT *
FROM employees
WHERE department NOT IN ('Sales', 'Marketing');

5. 子查询中的NOT IN

IN关键字也可以与NOT关键字一起使用，同时与子查询一起使用，实现匹配不在子查询结果中的数据，基本语法如下：

SELECT column1, column2, ...
FROM table_name
WHERE column_name NOT IN (SELECT column_name FROM table_name WHERE condition);

示例：

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