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






Calculate the power in procedure

       

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

   
    
    
    
    
    
    
  








Related examples in the same category

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