``` delimiter $$; create procedure test() begin declare i int default 1; declare num int default 0; while i<=100 do set num=num+i; set i=i+1; insert into a(name) values(num); end while; select num; end $$; ```