梦在脚下

create procedure pro_createcd()
begin 
 declare p_rolebaseid int;
 -- 这个用于处理游标到达最后一行的情况 
    declare stop int default 0; 
    -- 声明游标 
    declare cur cursor for select rolebaseid from drolecoolteam group by rolebaseid;
  -- 打开游标 
    open cur; 
     
    -- 读取一行数据到变量 
    fetch cur into p_rolebaseid; 
    -- 这个就是判断是否游标已经到达了最后 
    while stop <> 1 do
 insert into drolecoolteam(rolebaseid,coolid,cooltype,cooltime) values(p_rolebaseid,0,15,0);
        fetch cur into p_rolebaseid;
    end while;  -- 循环结束 
    close cur; -- 关闭游标 
end