mysql if statement evaluating int data type 0 to false?

ozzii · #1 (**permalink**) 03-21-09, 06:55

Hi

I have a mysql stored procedure e.g:

Code:

CREATE PROCEDURE simpleproc (param1 INT)

BEGIN
     IF param1 <> Null THEN
           #do something;
     END IF;
END;

If i call this procedure with param1 as 0 the if statement does nothing but works if param1 is of any other value other than 0. Why is the above statment evaluating param1 with a value of 0 as null?

r937 · #2 (**permalink**) 03-21-09, 07:08

NULL is not equal to any value, and NULL is not unequal to any value, either

try param IS NOT NULL

Internet Services

Web Development

Digital Marketing

Consumer Tech