mysql in和not in
2024-10-20 09:20:49
mysql> select * from table1;
+----------+------------+-----+---------------------+-------+
| name_new | transactor | pid | order_date | price |
+----------+------------+-----+---------------------+-------+
| 1hahha | 1xiaohong | | -- :: | |
| 2hahha | 2xiaohong | | -- :: | |
| 3hahha | 3xiaohong | | -- :: | |
| 4hahha | 4xiaohong | | -- :: | |
| 3hahha | bob | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | bob | | -- :: | |
| 3hahha | bob | | -- :: | |
+----------+------------+-----+---------------------+-------+
rows in set (0.00 sec) mysql> select * from table1 where pid in (,);
+----------+------------+-----+---------------------+-------+
| name_new | transactor | pid | order_date | price |
+----------+------------+-----+---------------------+-------+
| 2hahha | 2xiaohong | | -- :: | |
| 3hahha | bob | | -- :: | |
+----------+------------+-----+---------------------+-------+
rows in set (0.01 sec) mysql> select * from table1 where pid not in (,);
+----------+------------+-----+---------------------+-------+
| name_new | transactor | pid | order_date | price |
+----------+------------+-----+---------------------+-------+
| 1hahha | 1xiaohong | | -- :: | |
| 3hahha | 3xiaohong | | -- :: | |
| 4hahha | 4xiaohong | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | lee | | -- :: | |
| 3hahha | bob | | -- :: | |
| 3hahha | bob | | -- :: | |
+----------+------------+-----+---------------------+-------+
rows in set (0.00 sec)
最新文章
- Scala：映射和元组
- iptables基本操作
- vsPhere安装虚拟sm
- BZOJ3118 : Orz the MST
- light工具
- 配dump文件
- 浮点数精确表示，java陷阱
- js的数组操作
- 清风注解-Swift程序设计语言
- 转发一个javascript的编码规范
- BZOJ2127Happiness
- HBase指定大量列集合的场景下并发拉取数据时卡住的问题排查
- oracle之 any、some、all 解析
- StarUML最新版2.8.1简单使用及代码生成
- PHP的运行机制与原理(底层)
- ev的offsetX,pageX,clientX和screenX
- node 相关网站
- C++学习（二十）（C语言部分）之 函数1
- Android studio 自己定义打包APK名称
- 深入浅出MFC——Document-View深入探讨（五）