procedure

create procedure hoge()
begin
  declare counter int;
  declare hogehoge int;
  set @counter = 1;
  while @counter < 100 do
  set @hogehoge = ceil(RAND()*30000);
  update kadai1 set id=1 where id=@hogehoge;
  set @counter = @counter +1;
  select @hogehoge;
  end while;
end
//