A procedure can be creating in MySQL by using the following syntax:
CREATE PROCEDURE ProcedureName
(
param1 int,
param2 varchar(20)
)
BEGIN
– Text of stored procedure here
END;
Note that the name of the parameters cannot be the same as the names of any columns in tables that are referenced within the stored procedure.
