MySQL数据库 求N以内被3整除的数的和

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;

思路这样，第一次发不知道缩进之类的大家见谅。