top of page
71
MySQL 8.0
IS NOT NULL
Syntax:
IS NOT NULL
Tests whether a value is not NULL.
mysql> SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
-> 1, 1, 0
bottom of page
MySQL 8.0
Syntax:
IS NOT NULL
Tests whether a value is not NULL.
mysql> SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
-> 1, 1, 0