How MySQL NULLIF() control flow function is similar to CASE statement?

MySQLMySQLi Database

As we know that MySQL NULLIF() control flow function will return NULL if both the arguments are the same, otherwise it returns the first argument. Hence it is similar to the following CASE statement −

CASE
WHEN expression1=expression2 THEN NULL
ELSE
Expression2
END.
raja
Published on 21-Feb-2018 15:28:24
Advertisements