Syntax for Creating store procedures : Procedure « Procedure Function « SQL / MySQL






  1. SQL / MySQL
  2. Procedure Function
  3. Procedure

Syntax for Creating store procedures

       

CREATE FUNCTION name ([parameterlist]) RETURNS datatype
[options] sqlcode
CREATE PROCEDURE name ([parameterlist])
[options] sqlcode








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.Calculate the power in procedure
8.Cleanup table with procedure
9.Compare value in a procedure
10.Output comparison value from a procedure
11.Find out the age with procedure
12.Syntax for Changing store procedures
13.Drop table by procedure