创建一个程序来找出数字的阶乘？
可以在以下查询的帮助下创建它-
mysql> Delimiter //
mysql> CREATE PROCEDURE fact(IN x INT)
-> BEGIN
-> DECLARE result INT;
-> DECLARE i INT;
-> SET result = 1;
-> SET i = 1;
-> WHILE i <= x DO
-> SET result = result * i;
-> SET i = i + 1;
-> END WHILE;
-> SELECT x AS Number, result as Factorial;
-> END//现在，当通过传递我们想要获取阶乘作为参数的值来调用此过程时，-
mysql> Delimiter ; mysql> CALL Fact(5); +--------+-----------+ | Number | Factorial | +--------+-----------+ | 5 | 120 | +--------+-----------+ 1 row in set (0.00 sec) mysql> CALL Fact(6); +--------+-----------+ | Number | Factorial | +--------+-----------+ | 6 | 720 | +--------+-----------+ 1 row in set (0.00 sec)
热门推荐
10 对转校同学祝福语简短
11 微信立冬祝福语简短
12 高考成绩高分祝福语简短
13 新郎朋友祝福语简短大气
14 鼠年同事祝福语简短创意
15 升职加薪的祝福语简短
16 祝福语闺蜜简短单纯
17 新年祝福语简短俏皮文案
18 物业小区高考祝福语简短