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 resu.
原创
2020-08-20 16:53:29 ·
427 阅读 ·
0 评论