BEGIN
declare teamId,userId int default 0;
declare done int default -1;
/* 声明游标 */
declare myCursor cursor for select CK_USER_TEAM_id,users_id from ck_team_user;
/* 当游标到达尾部时,mysql自动设置done=1 */
declare continue handler for not found set done=1;
/* 打开游标 */
open myCursor;
/* 循环开始 */
myLoop: LOOP
/* 移动游标并赋值 */
FETCH myCursor INTO teamId, userId; /*获取第一条记录*/
if done = 1 then
leave myLoop;
end if;
/* do something
set sum = sum + tmp; */
insert into ck_user_teamuser_copy(team_id,user_id,createTime) values(teamId,userId,NOW());
/* 循环结束 */
end loop myLoop;
/* 关闭游标 */
close myCursor;
END
declare teamId,userId int default 0;
declare done int default -1;
/* 声明游标 */
declare myCursor cursor for select CK_USER_TEAM_id,users_id from ck_team_user;
/* 当游标到达尾部时,mysql自动设置done=1 */
declare continue handler for not found set done=1;
/* 打开游标 */
open myCursor;
/* 循环开始 */
myLoop: LOOP
/* 移动游标并赋值 */
FETCH myCursor INTO teamId, userId; /*获取第一条记录*/
if done = 1 then
leave myLoop;
end if;
/* do something
set sum = sum + tmp; */
insert into ck_user_teamuser_copy(team_id,user_id,createTime) values(teamId,userId,NOW());
/* 循环结束 */
end loop myLoop;
/* 关闭游标 */
close myCursor;
END