Mysql存储过程异常处理

-- 异常处理
DECLARE result_code CHAR(5) DEFAULT '00000'; DECLARE msg TEXT;DECLARE set_error_code CHAR(1);    
DECLARE result_info,success_info TEXT;
DECLARE a float;
DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN         
        GET DIAGNOSTICS CONDITION 1 result_code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT;        
        ROLLBACK;
        SET result_info = CONCAT('执行失败,错误代码:',result_code,',错误信息:',CHAR(13),CHAR(10),IFNULL(msg,''));
        set un = result_info; 
END;