怎样用mysql实现阶乘

数据运维 2023-08-16 大白菜程序猿 手机阅读

DELIMITER $$ CREATE PROCEDURE factorial(IN num INT, OUT res BIGINT) BEGIN DECLARE i INT DEFAULT 0; DECLARE fact BIGINT DEFAULT 1; SET i = 1; WHILE i