©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
NULL functions in MySQL and MariaDB

MySQL and MariaDB - Overview of the NULL functions

MySQL and MariaDB provides a set of NULL functions that can be used to handle NULL values in SQL queries. NULL functions can be useful when working with data that may contain NULL values. They can be used to handle NULL values in a consistent and predictable way, and to ensure that queries return accurate and complete results. However, it is important to use them carefully and to ensure that they are used appropriately for the specific use case.

Gibt das erste Nicht-NULL-Argument zurück.
More about COALESCE Function
IFNULLIFNULL(Expression, Value)
Gibt [Wert] zurück, wenn [Ausdruck] NULL ist, sonst [Ausdruck].
More about IFNULL Function

Testet ob das Argument NULL ist.
More about ISNULL Function
NULLIFNULLIF(Expression 1, Expression 2)
Gibt NULL zurück, wenn [Ausdruck 1] = [Ausdruck 2].
More about NULLIF Function
NVLNVL(Expression, Value)
Gibt [Wert] zurück, wenn [Ausdruck] NULL ist, sonst [Ausdruck]. Oracle-Kompatible.
More about NVL Function

NVL2NVL2(Expression, Value1, Value2)
Gibt einen von zwei Werten basierend darauf zurück, ob ein angegebener Ausdruck NULL ist oder nicht. Oracle-Kompatible.
More about NVL2 Function

See also: List of all MySQL and MariaDB built-in functions
Updated: 2023-09-22ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer