Collections:
ISNULL() - Detecting NULL Value
How to detect a NULL value using the ISNULL() function?
✍: FYIcenter.com
ISNULL(val) is a MySQL built-in function that
returns 1 if the given value is NULL, 0 otherwise.
For example:
SELECT ISNULL(1+1); -- +-------------+ -- | ISNULL(1+1) | -- +-------------+ -- | 0 | -- +-------------+ SELECT ISNULL(1/0); -- +-------------+ -- | ISNULL(1/0) | -- +-------------+ -- | 1 | -- +-------------+
Reference information of the ISNULL() function:
ISNULL(val): boolean Returns TRUE, if and only if the argument is NULL. Arguments, return value and availability: val: Required. The value to be examined. boolean: Return value. TRUE, if and only if the argument is NULL. Available since MySQL 4.0.
⇒ LEAST() - Finding the Least/Minimum Value
⇐ IS_USED_LOCK() - Checking Lock Owner
2026-07-13, 2093🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...