My SQL 存储过程 游标

DROP PROCEDURE IF EXISTS createAppUserConfig;


CREATE PROCEDURE createAppUserConfig()


BEGIN
DECLARE _userId BIGINT; -- 申明变量
DECLARE done int; -- 申明变量


DECLARE rs_cursor CURSOR FOR SELECT userid from app_user; -- 申明游标
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN rs_cursor; -- 打开游标
cursor_loop:LOOP --对游标进行循环
FETCH rs_cursor INTO _userId; -- 在游标中取值

if done = 1 THEN
leave cursor_loop;
end if;
INSERT INTO user_flowconfig (appUserId,isAgent,isEmail,isMsg) values (_userId,1,1,1); 
end LOOP cursor_loop; -- 关闭循环
close rs_cursor; -- 关闭游标
END