mysql循环（while..do,loop..leave,repeat..util)

求和：计算从1到n的和

一、while…do

while…do相当于java中的whlie循环

delimiter//
create function testsum(num int)
returns int
begin
declare i int default 0;
declare sum int default 0;
while i<=num do
	set sum=sum+i;
	set i=i+1;
end while;
return sum;
end//
delimiter;

select testsum(10);

二、loop…leave

loop…leave相当于java中的while（true）+break

delimiter//
create function testsum(num int)
returns int
begin
declare i int default 0;
declare sum int default 0;
lable1:loop
	set sum=sum+i;
	set i=i+1;
	if i>num then
		leave lable1;
	end if;
end loop lable1;
return sum;
end//
delimiter;

select testsum(10);

三、repeat…until

repeat…until相当于java中的do…while循环

delimiter//
create function testsum(num int)
returns int
begin
declare i int default 0;