Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns true if the value is NULL.
ISNULL (val)
(val IS NULL)
Boolean
SELECT ISNULL(NULL), ISNULL(0), (NULL + 0 is NULL), (0 is NULL);
+--------------+-----------+--------------------+-------------+
| ISNULL(NULL) | ISNULL(0) | (NULL + 0 is NULL) | (0 is NULL) |
+--------------+-----------+--------------------+-------------+
| 1 | 0 | 1 | 0 |
+--------------+-----------+--------------------+-------------+