Re: Suspend Warnings for Specific Query

[Roland Bouman]

You should define a HANDLER for the NOT FOUND condition. Declare that *after* all other declarations:

DECLARE CONTINUE HANDLER FOR NOT FOUND
set appId := 0;

This will assign zero to appId whenever the query yields no records, and continue execution right after the SELECT INTO.

see:

http://dev.mysql.com/doc/mysql/en/conditions-and-handlers.html

and follow both links from there to read all about it.