DELIMITER $$DROP FUNCTION IF EXISTS `colorful_site_test`.`func_recursion`$$CREATE FUNCTION `colorful_site_test`.`func_recursion`( f_value int,f_n int) RETURNS bigint unsigned BEGIN declare result bigint; if f_n = 0 then return 1; elseif f_n = 1 then return f_value; else set result = func_recursion(f_value,f_n-1) * f_value; return result; end if; END$$DELIMITER ; mysql> select func_recursion(4,2); ERROR 1424 (HY000): Recursive stored functions and triggers are not allowed. mysql> 不支持 用循环吧 。
DELIMITER $$DROP FUNCTION IF EXISTS `colorful_site_test`.`func_recursion`$$CREATE FUNCTION `colorful_site_test`.`func_recursion`(
f_value int,f_n int)
RETURNS bigint unsigned
BEGIN
declare result bigint;
if f_n = 0 then
return 1;
elseif f_n = 1 then
return f_value;
else
set result = func_recursion(f_value,f_n-1) * f_value;
return result;
end if;
END$$DELIMITER ;
mysql> select func_recursion(4,2);
ERROR 1424 (HY000): Recursive stored functions and triggers are not allowed.
mysql>
不支持
用循环吧 。