IFNULL() with NULL and NOT NULL value : IFNULL « Control Flow Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Control Flow Functions
  3. IFNULL
mysql>
mysql> SELECT IFNULL(NULL,'The value is Null');
+----------------------------------+
| IFNULL(NULL,'The value is Null') |
+----------------------------------+
| The value is Null                |
+----------------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT IFNULL(10,'The value is Null');
+--------------------------------+
| IFNULL(10,'The value is Null') |
+--------------------------------+
| 10                             |
+--------------------------------+
1 row in set (0.00 sec)

mysql>








18.4.IFNULL
18.4.1.IFNULL(expr1,expr2)
18.4.2.Using IFNULL in where clause
18.4.3.Using IFNULL with data in a table
18.4.4.Create a table based on the result of IFNULL
18.4.5.IFNULL() with NULL and NOT NULL value
18.4.6.Use the IFNULL() function to specify a zero in place of the NULL figure