MySQL Create Procedure
The MySQL Create Procedure Tool allows users to create stored procedures for a database. The following example is output for MySQL.
create procedure sample.test_procedure (IN param1 CHAR(25),
INOUT param2 DATE,OUT param3 DECIMAL)
--insert procedure body here
