CREATE PROCEDURE `proname`(uid int,rid int,out errorno int,...)
top:BEGIN
....
leave top;
top:BEGIN
....
leave top;
END;
http://www.jzxue.com/shujuku/mysql/201003/04-3562.html