MySQL IS NULL
IS NULL
MySQL IS NULL operator tests whether a value is NULL. If satisfied, then returns 1 otherwise returns 0.
Syntax:
IS NULL
MySQL Version: 8.0
Example : MySQL IS NULL
In the following MySQL statement, it is checked whether 2, 0 and NULL are NULL, using IS NULL operator.
Code:
SELECT 2 IS NULL, 0 IS NULL, NULL IS NULL;
Output:
mysql> SELECT 2 IS NULL, 0 IS NULL, NULL IS NULL; +-----------+-----------+--------------+ | 2 IS NULL | 0 IS NULL | NULL IS NULL | +-----------+-----------+--------------+ | 0 | 0 | 1 | +-----------+-----------+--------------+ 1 row in set (0.00 sec)
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics