Create procedure for definer : Introduction « Procedure Function « SQL / MySQL






Create procedure for definer

       

CREATE DEFINER = 'CHRIS3'@'%' PROCEDURE PIPOWER
   (OUT VAR1 DECIMAL(10,5))
BEGIN
   SET VAR1 = POWER(PI(),2);
END

   
    
    
    
    
    
    
  








Related examples in the same category

1.Using user-defined function in a select statement
2.Use user-defined function in a select statement to deal with data in a table
3.Use user-defined function in order by clause
4.Use user-defined function in where clause
5.Recursion
6.Using aggregate function in procedure
7.Determining the Code of an stored procedures