43.笔记 MySQL学习——EXISTS 和 NOT EXISTS子查询
运算符EXISTS和 NOT EXISTS只会测试某个子查询是否返回了行。如果有返回,EXISTS为真,而NOT EXISTS结果为假。
mysql> select exists (select * from absence);
+--------------------------------+
| exists (select * from absence) |
+--------------------------------+
| 1 |
+--------------------------------+
1 row in set (0.00 sec)
mysql> select not exists (select * from absence);
+------------------------------------+
| not exists (select * from absence) |
+------------------------------------+
| 0 |
+------------------------------------+
1 row in set (0.00 sec)
在相关子查询中比较常见。