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, 2097🔥, 0💬
Popular Posts:
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle? If you have a group of commands...
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a m...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...