MySQL存储过程-遍历游标的例子

delimiter $$
DROP PROCEDURE IF EXISTS pro_test ;
CREATE PROCEDURE pro_test()
begin
DECLARE var_name varchar(50);

DECLARE fee_18 CURSOR FOR
select name from test;
DECLARE EXIT HANDLER FOR NOT FOUND CLOSE fee_18;

OPEN fee_18;
REPEAT
FETCH fee_18 into var_name;
insert into test2 select var_name;

UNTIL 0 END REPEAT;
CLOSE fee_18;
end;
$$
DELIMITER ;

 

转载于:https://www.cnblogs.com/liang545621/p/10122692.html