Stored Procedure Coding Style

All stored procedures in MySQL will have the following basic structure:

DELIMITER$$

CREATE DEFINER=`user`@`host` PROCEDURE `p_module_StoredProcedureName` (IN i_ParameterOne,
IN i_ParameterTwo,
INOUT io_ParameterThree)
MODIFIES SQL DATA | READS SQL DATA
SQL SECURITY INVOKER
BEGIN
DECLARE v_InternalVariable BIGINT;
...
END$$