Calculate the power in procedure

       

CREATE PROCEDURE POWERPOWER
   (IN P1 INTEGER, OUT P2 INTEGER)
   DETERMINISTIC
BEGIN
   SET P2 = POWER(POWER(P1,2),2);
END

1.	Using an OUT parameter
2.	Creating a Single-Statement Procedure
3.	Calling a Single-Statement Procedure
4.	Creating a Multistatement Stored Procedure
5.	The ALTER statement lets you change the characteristics of a stored procedure
6.	To remove a stored procedures, use the DROP statement
7.	Cleanup table with procedure
8.	Compare value in a procedure
9.	Output comparison value from a procedure
10.	Find out the age with procedure
11.	Syntax for Changing store procedures
12.	Syntax for Creating store procedures
13.	Drop table by procedure

Calculate the power in procedure : Procedure « Procedure Function « SQL / MySQL