How can I write a MySQL stored function that calculates the factorial of a given number?

Following is the example of a stored function that can calculate the factorial of a given number −

CREATE FUNCTION factorial (n DECIMAL(3,0))
RETURNS DECIMAL(20,0)
DETERMINISTIC
BEGIN
DECLARE factorial DECIMAL(20,0) DEFAULT 1;
DECLARE counter DECIMAL(3,0);
SET counter = n;
factorial_loop: REPEAT
SET factorial = factorial * counter;
SET counter = counter - 1;
UNTIL counter = 1
END REPEAT;
RETURN factorial;
END //

mysql> Select Factorial(5)//
+--------------+
| Factorial(5) |
+--------------+
|          120 |
+--------------+
1 row in set (0.27 sec)

mysql> Select Factorial(6)//
+--------------+
| Factorial(6) |
+--------------+
|          720 |
+--------------+
1 row in set (0.00 sec)

Radhakrishna

Published on 21-Feb-2018 12:07:19

• Related Questions & Answers
• How to write a MySQL stored function that updates the values in a table?
• How to write a MySQL stored function that inserts values in a table?
• Write a Golang program to find the factorial of a given number (Using Recursion)
• How can I use MySQL OCTET_LENGTH() function to count the number of characters stored in a data column?
• How can I create a MySQL stored procedure that returns multiple values from a MySQL table?
• How can we alter a MySQL stored function?
• How can we create a MySQL stored function that uses the dynamic data from a table?
• How can we create MySQL stored procedure to calculate the factorial?
• How can we write MySQL handler in a stored procedure?
• Write a function that counts the number of times a given int occurs in a Linked List in C++
• How can I find the number of arguments of a Python function?
• How can we write MySQL handler, in a stored procedure, that sets the particular value of a variable and continues the execution?
• How can we delete a MySQL stored function from the database?
• How can we see the source code of a particular MySQL stored function?
• How can we write MySQL handler, in a stored procedure, that throws an error message and continues the execution?