MySQL NULLIF() Function NULL Value Example

MySQL NULLIF() Function NULL Value Example

Open your MySQL Query Editor then copy & paste the below code to get the value of NULLIF() MySQL Function NULL Value Example:

   SELECT NULLIF(NULL,NULL), NULLIF(NULL,'NOT NULL'), NULLIF(0/0,'NOT NULL');

   -- MySQL NULLIF() Function Deals With Two Expressions
   --
   -- IF    [Expression1/Value1] equals to [Expression2/Value2] NULLIF() Function returns NULL
   -- ELSE  NULLIF() Function returns [Expression1/Value1]

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

MySQL NULLIF() Function NULL Value Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL NULLIF() Nested Function Example
2. MySQL NULLIF() Function Datetime Value Example
3. MySQL NULLIF() Function String Value Example
4. MySQL NULLIF() Function Number Value Example
5. MySQL NULLIF() Function Boolean Value Example
6. MySQL IFNULL() Function Datetime Example
7. MySQL Stored Procedure Function: How to Drop a Stored Procedure Example
8. MySQL Stored Procedure Function: Making hello world Function using aliase Example
9. MySQL Stored Procedure: Creating Table using Stored Procedure Example
10. Operator precedence in SQL Command MySQL Example