mysql 存储过程 游标

DELIMITER //
CREATE PROCEDURE test_name3()
BEGIN 
DECLARE test_name VARCHAR(30); 
DECLARE done INT DEFAULT FALSE;
DECLARE test_cur CURSOR FOR  SELECT pipei.name FROM pipei LIMIT 10000;
DECLARE EXIT HANDLER FOR NOT FOUND CLOSE test_cur;
 
OPEN test_cur;  
tLoop: LOOP  
FETCH test_cur INTO test_name; 
INSERT INTO result SELECT a.member_code,a.member_name,test_name FROM  test a WHERE a.member_name LIKE CONCAT('%',test_name,'%');
IF done THEN  
LEAVE tLoop; 
END IF;  
END LOOP tLoop; 
CLOSE test_cur;  
END; 
//


CALL test_name3;