All pages
Powered by GitBook
1 of 1

Loading...

IS NOT NULL

Syntax

IS NOT NULL

Description

Tests whether a value is not NULL. See also NULL Values in MariaDB.

Examples

See also

This page is licensed: GPLv2, originally from

NULLIF function
  • CONNECT data types

  • NULL values
    IS NULL operator
    COALESCE function
    IFNULL function
    fill_help_tables.sql
    SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
    +---------------+---------------+------------------+
    | 1 IS NOT NULL | 0 IS NOT NULL | NULL IS NOT NULL |
    +---------------+---------------+------------------+
    |             1 |             1 |                0 |
    +---------------+---------------+------------------+