Create a procedure to find out the factorial of a number?

It can be created with the help of the following query −

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//
Query OK, 0 rows affected (0.17 sec)

Now when invoking this procedure by passing the value of which we want to get the factorial as an argument −

mysql> Delimiter ;
mysql> CALL Fact(5);
+--------+-----------+
| Number | Factorial |
+--------+-----------+
|      5 |       120 |
+--------+-----------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> CALL Fact(6);
+--------+-----------+
| Number | Factorial |
+--------+-----------+
|      6 |       720 |
+--------+-----------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

vanithasree

Updated on 22-Jun-2020 07:21:33

• Related Questions & Answers
• 8085 program to find the factorial of a number
• 8086 program to find the factorial of a number
• Java Program to Find Factorial of a number
• How to Find the Factorial of a Number using Python?
• Python program to find factorial of a large number
• Python Program to find the factorial of a number without recursion
• Factorial of a large number
• C++ Program to Find Factorial of a Number using Iteration
• C++ Program to Find Factorial of a Number using Recursion
• Java Program to Find Factorial of a Number Using Recursion
• How can we create MySQL stored procedure to calculate the factorial?
• Java program to find the factorial of a given number using recursion
• Find the factorial of a number in pl/sql using C++.
• Write a Golang program to find the factorial of a given number (Using Recursion)
• C++ Program to find out the number of cells to block in a grid to create a path