MySQL Stored procedure example

DELIMITER $$

DROP PROCEDURE IF EXISTS `mycash`.`addUnit` $$
CREATE PROCEDURE `mycash`.`addUnit` (in_name varchar(45),
in_type enum('Home', 'Organization', 'Community'),
in_country_code tinyint,
in_area_code smallint,
in_pincode integer,
in_street_address text
)
BEGIN
INSERT INTO `unit` (`name`, `type`, `country_code`, `area_code`, `pincode`, `street_address`, `creation_date`)
VALUES (in_name, in_type, in_country_code, in_area_code, in_pincode, in_street_address, CURRENT_DATE);
END $$

DELIMITER ;