Re: In Stored Procedure, how to check if variable is NULL?

[Roland Bouman]

Sorry, the snippet from my previous post should read:

IF
l_UserID IS NULL
THEN
SELECT FirstName, LastName, EMail FROM Users WHERE UserID = l_UserID;
END IF;


so, the full pattern is:

IF <condition> THEN
<statements>
END IF;

as for the condition,

<expr> IS NULL

is an ordinary valid condition, even ;) in IF..THEN..END IF statements.

See:

http://dev.mysql.com/doc/mysql/en/if-statement.html