MySQL While 循环小例子

-- MySQL While循环例子
 delimiter $$
create procedure p_file_t()
begin
  declare a int;
  set a=1;
  loop1:while a<3 do
         insert into drbd_t(hash,path) values('abcd123456', '/192.168.250.100/file');
        select a;
  set a=a+1;
  end while loop1;
 end $$