mysql> select NULL + 2, NULL - 3, NULL * 4, NULL / 2, NULL DIV 6, NULL MOD 7;
+----------+----------+----------+----------+------------+------------+
| NULL + 2 | NULL - 3 | NULL * 4 | NULL / 2 | NULL DIV 6 | NULL MOD 7 |
+----------+----------+----------+----------+------------+------------+
| NULL | NULL | NULL | NULL | NULL | NULL |
+----------+----------+----------+----------+------------+------------+
1 row in set (0.00 sec)
从上面的结果可以看出,凡是有NULL值参与的运算结果都是NULL。