Question

Write a script in MySQL that creates and calls a stored procedure name test. This procedure should calculate the factorial for the number 10. (To calculate a factorial, you multiply an integer less than itself.) Then, it should display a string that includes the factorial like this: The factorial of 10 is: 3,628,800.

Answer 1

Answer:

DELIMITER $$
CREATE PROCEDURE factorial()
BEGIN
DECLARE n INT;
DECLARE fact INT;
DECLARE str TEXT;

   SET n = 10;
SET fact = 1;
   WHILE n > 0 DO
SET fact = fact * n;
SET n = n - 1;
END WHILE;
SET str = CONCAT('The factorial of 10 is: ', fact);
SELECT str;
END$$

DELIMITER ;

Explanation: factorial () procedure is created. It have n and fact as a integer variable and str as string variable.

n used to store number 10, fact is used to store factorial of 10 and str is used to store result.

While loop is used to calculate factorial.

Calling the Procedure: Execute following command,

CALL factorial();

Screen: