Collections:
NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function?
✍: FYIcenter.com
NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example:
SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+---------------------+ -- | NULLIF('yes', 'yes') | NULLIF('yes', 'no') | -- +----------------------+---------------------+ -- | NULL | yes | -- +----------------------+---------------------+
Reference information of the NULLIF() function:
NULLIF(val1, val2): val Returns NULL if the first argument equals the second, the first argument otherwise. Arguments, return value and availability: val1, val2: Required. The values to be selected from. val: Return value. NULL if val1=val2, val1 otherwise. Available since MySQL 4.0.
⇒ RELEASE_ALL_LOCKS() - Release All Locks
⇐ NAME_CONST() - PS Thread ID of Given Connect
2023-12-19, 304🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...