mysql 捕获异常实例

delimiter ;;
create procedure testhanderdemo(out ret int )
begin
  DECLARE EXIT HANDLER FOR SQLEXCEPTION  --当有异常退出 并将ret 设为 -1
  begin
    set ret = -1;
  end;
  set ret = 0;
  insert into t1(id,a,b) values(1,1,1);  --此语句会造成主键重复的报错
end
delimiter ;

call testhanderdemo(@ret);
select @ret;   -- @ret 返回为 -1