|
需要注意的是输出参数也是要初始化的，不然就是null值。
drop procedure cursor_user;
delimiter //
create procedure cursor_user(out result varchar(2000))
BEGIN
declare a varchar(20);
declare done int;
declare cur CURSOR FOR select id from test.`user`;
DECLARE CONTINUE HANDLER for not found SET done = 1;
open cur;
set result = '';
repeat
FETCH cur into a;
SELECT CONCAT(a,result) into result;
#SELECT result;
until done end repeat;
#SELECT result;
CLOSE cur;
END;
//
delimiter ;
/*启动游标遍历*/
set @a = 'hi';
#SELECT @a;
call cursor_user(@a);
select @a;
(责任编辑：IT) |