Hello All,
Is there an equivalent to the nvl() function of Oracle available in MySql. I
am currently using version 4.1 alpha and am trying to execute the following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
Also, I tried to create a user defined function as below, but it
What does nvl do? Here is a list of the functions from the MySQL manual:
http://www.mysql.com/doc/en/Function_Index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:
Is there an equivalent to the nvl() function of Oracle available in
MySql. I
am currently using version 4.1 alpha and am trying to execute the
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
In MySQL, the function