-- 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 $$