DELIMITER $$

DROP PROCEDURE IF EXISTS `proc_almacen`.`procedure1` $$
CREATE PROCEDURE `proc_almacen`.`procedure1` (in parameter1 INTEGER)
BEGIN
DECLARE variable1 CHAR(10);
		IF parameter1 = 17 THEN
			SET variable1 = 'birds';
		ELSE
			SET variable1 = 'beasts';
		END IF;
		INSERT INTO table1 VALUES (variable1);


END $$

DELIMITER ;