Re: exiting a store procedure?

[Roland Bouman]

1) yes:


create procedure myProc(param1 int)
main_block: begin
if
param1 is null
then
leave main_block;
end if;
end main_block;

2) yes, you're can declare handler for any SQLSTate or mysql errorcode. And you can name these using a CONDITION declaration see:

http://dev.mysql.com/doc/refman/5.0/en/declare-conditions.html
http://dev.mysql.com/doc/refman/5.0/en/declare-handlers.html