比较运算符中使用NULL
mysql> select 1>NULL;
+--------+
| 1>NULL |
+--------+
| NULL |
+--------+
1 row in set (0.00 sec)
mysql> select 1<NULL;
+--------+
| 1<NULL |
+--------+
| NULL |
+--------+
1 row in set (0.00 sec)
mysql> select 1<>NULL;
+---------+
| 1<>NULL |
+---------+
| NULL |
+---------+
1 row in set (0.00 sec)
mysql> select 1>NULL;
+--------+
| 1>NULL |
+--------+
| NULL |
+--------+
1 row in set (0.00 sec)
mysql> select 1<NULL;
+--------+
| 1<NULL |
+--------+
| NULL |
+--------+
1 row in set (0.00 sec)
mysql> select 1>=NULL;
+---------+
| 1>=NULL |
+---------+
| NULL |
+---------+
1 row in set (0.00 sec)
mysql> select 1<=NULL;
+---------+
| 1<=NULL |
+---------+
| NULL |
+---------+
1 row in set (0.00 sec)
mysql> select 1!=NULL;
+---------+
| 1!=NULL |
+---------+
| NULL |
+---------+
1 row in set (0.00 sec)
mysql> select 1<>NULL;
+---------+
| 1<>NULL |
+---------+
| NULL |
+---------+
1 row in set (0.00 sec)
mysql> select NULL=NULL,NULL!=NULL;
+-----------+------------+
| NULL=NULL | NULL!=NULL |
+-----------+------------+
| NULL | NULL |
+-----------+------------+
1 row in set (0.00 sec)
mysql> select 1 in (null),1 not in (null),null in (null),null not in (null);
+-------------+-----------------+----------------+--------------------+
| 1 in (null) | 1 not in (null) | null in (null) | null not in (null) |
+-------------+-----------------+----------------+--------------------+
| NULL |