Re: Declare variable inside a function

[William Chiquito]

Hi Jon,

Try:

DELIMITER $$

DROP FUNCTION IF EXISTS `fn_GetYearAlbumRank`$$

CREATE FUNCTION `fn_GetYearAlbumRank`(parmAlbumID INT, parmYear INT)
	RETURNS INT
BEGIN
	DECLARE retval INT;
	SELECT 5 INTO retval;
	RETURN retval;
END$$

DELIMITER ;

SELECT fn_GetYearAlbumRank(1,2);

Result:

fn_GetYearAlbumRank(1,2)
------------------------
                       5