SQL NULL Functions
Below given are the SQL NULL functions
ISNULL()
NVL()
IFNULL()
COALESCE()
We can use these function to manage the null values .
mysql> SELECT 1+IFNULL(age,0) as age FROM users ;
+—–+
| age |
+—–+
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
+—–+
5 rows in set (0.00 sec)
Beginner's Guide....
