create function fun_3sum(v_n int)
returns int
begin
declare v_3sum int;
declare i int;
set i =v_n;
set v_3sum = 0;
a:loop
if mod(i,3)=o then
set v_3sum = v_3sum+i;
end if;
set i =i+1
if i>v_n then leave a ;
end if
end loop a;
return v_3sum;
end;
select fun_3sum
求1,2...n 的阶乘
create function fun_jc(v_n int)
return big int
begin
declare v_jc big int;
declare i int;
set v_jc =1;
set i =v_n;
a:loop
set v_jc = v_jc*i;
set i=i-1;
if i=0 then leave a;
思路这样,第一次发不知道缩进之类的大家见谅。