MySQL stored procedure skeleton

gistfile1.txt

##################
# BASIC SKELETON #
##################

DELIMITER $$

USE `database-name`$$

DROP PROCEDURE IF EXISTS `database-name`.`procName` $$
CREATE PROCEDURE `database-name`.`procName` (IN varName1 VARCHAR(30), IN varName2 VARCHAR(30), IN varName3 INT)
COMMENT '
Author: Carlton Dickson <email@gmail.com>
Date: DD/MM/YYYY
Skeleton stored procedure for MySQL
'
label:BEGIN

LEAVE label;

END $$
DELIMITER ;

###################
# INSERT SKELETON #
###################

DELIMITER $$

USE `database-name`$$

DROP PROCEDURE IF EXISTS `database-name`.`procName` $$
CREATE PROCEDURE `database-name`.`procName` (IN varName1 VARCHAR(30), IN varName2 VARCHAR(30), IN varName3 INT)
COMMENT '
Author: Carlton Dickson <email@gmail.com>
Date: DD/MM/YYYY
Skeleton stored procedure for MySQL
'
label:BEGIN

INSERT INTO `table` (
    `table`.`col1`,
    `table`.`col2`,
    `table`.`col3`
) 
VALUES
(
    'x',
    'y',
    'z'
) ;

SET @lastInsertID = LAST_INSERT_ID();

LEAVE label;

END $$
DELIMITER ;