56,675
社区成员
发帖
与我相关
我的任务
分享
CREATE DEFINER=`root`@`%` PROCEDURE `InitUserMail`(strIds varchar(500))
BEGIN
declare uid int;
declare done int;
call splitString(strIds,",");
DECLARE rs_cursor CURSOR FOR select status from tmp_split;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
set done = 0;
open rs_cursor;
cursor_loop:loop
FETCH rs_cursor into uid;
if done=1 then
leave cursor_loop;
end if;
if uid then
call CreateUserMailOption(uid);
call CreateUserMailBox(uid);
end if;
end loop cursor_loop;
close rs_cursor;
END