mysql之in与not in

1. in

作用：查询某个范围内的数据。

mysql> select * from t_employee;
+----+--------+------------+--------+-----+
| id | name   | address    | salary | sex |
+----+--------+------------+--------+-----+
|  5 | 小明   | 四川       |   6978 | f   |
|  6 | 小兰   | 天津       |  12000 | f   |
|  7 | 张三   | 广东       |   9807 | f   |
|  9 | 小华   | 广东       |  12000 | f   |
| 10 | 小静   | 山东       |   7980 | m   |
| 11 | 王小二 | 上海       |   9809 | f   |
| 12 | 王二   | 中山火炬区 |  10000 | m   |
| 13 | 小龄   | 上海       |   3000 | f   |
| 15 | 小煦   | 海南       |   2334 | m   |
+----+--------+------------+--------+-----+
9 rows in set

mysql> select * from t_employee where salary in(12000,10000,30000);
+----+------+------------+--------+-----+
| id | name | address    | salary | sex |
+----+------+------------+--------+-----+
|  6 | 小兰 | 天津       |  12000 | f   |
|  9 | 小华 | 广东       |  12000 | f   |
| 12 | 王二 | 中山火炬区 |  10000 | m   |
+----+------+------------+--------+-----+
3 rows in set

2. not in

作用：查询不在该范围的数据。

mysql>  select * from t_employee where salary not in(12000,10000,30000);
+----+--------+---------+--------+-----+
| id | name   | address | salary | sex |
+----+--------+---------+--------+-----+
|  5 | 小明   | 四川    |   6978 | f   |
|  7 | 张三   | 广东    |   9807 | f   |
| 10 | 小静   | 山东    |   7980 | m   |
| 11 | 王小二 | 上海    |   9809 | f   |
| 13 | 小龄   | 上海    |   3000 | f   |
| 15 | 小煦   | 海南    |   2334 | m   |
+----+--------+---------+--------+-----+