Tag: nvl mysql equivalent

• June 23, 2012

  Oracle NVL equivalent in MySQL

  Read – What is Oracle NVL Many Oracle Developers who write code in MySQL will look for this solution. Answer 1 :- IFNULL Answer 2 :- COALESCE ( It returns first not null expression in the list) IFNULL mysql> select IFNULL(null,1); will return 1 COALESCE mysql> select COALESCE(null,1); will return 1 Note:- COALESCE will work […]