存储过程:游标

最新推荐文章于 2018-08-13 15:43:10 发布

种子之家

最新推荐文章于 2018-08-13 15:43:10 发布

阅读量329

点赞数

分类专栏： MySql

本文链接：https://blog.csdn.net/seeds_home/article/details/7886489

版权

MySql 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

drop table if exists t;  
  
create table t (s1 int);    

delete from t;
   
insert into t values (5);    
insert into t values (4);   
  
select * from t;  


drop procedure if exists p25;

delimiter //

create procedure p25 (out return_val int)  
begin  
  declare a,b int;  
  declare cur_1 cursor for select s1 from t;  
  declare continue handler for not found  
    set b = 1;  
  open cur_1;  
  repeat  
    fetch cur_1 into a;  
    until b = 1  
  end repeat;  
  close cur_1;  
  set return_val = a;                                   
end;//   

delimiter ;

call p25(@return_val);

select @return_val;

/*
*/