夢在腳下

create procedure pro_createcd()
begin 
 declare p_rolebaseid int;
 -- 這個(gè)用于處理游標(biāo)到達(dá)最后一行的情況 
    declare stop int default 0; 
    -- 聲明游標(biāo) 
    declare cur cursor for select rolebaseid from drolecoolteam group by rolebaseid;
  -- 打開游標(biāo) 
    open cur; 
     
    -- 讀取一行數(shù)據(jù)到變量 
    fetch cur into p_rolebaseid; 
    -- 這個(gè)就是判斷是否游標(biāo)已經(jīng)到達(dá)了最后 
    while stop <> 1 do
 insert into drolecoolteam(rolebaseid,coolid,cooltype,cooltime) values(p_rolebaseid,0,15,0);
        fetch cur into p_rolebaseid;
    end while;  -- 循環(huán)結(jié)束 
    close cur; -- 關(guān)閉游標(biāo) 
end