Exemplo de criação simples de procedures e funcions no mysql

simple_mysql_procedure.sql

DELIMITER //

DROP FUNCTION IF EXISTS `TSTE_BVASE`//

CREATE FUNCTION `TSTE_BVASE`() RETURNS TINYINT
BEGIN
	DECLARE agora DATETIME;
    
    SET agora = now();

	IF @agora>now() THEN RETURN 1;
	ELSE RETURN 0;
    END IF;
END//

DELIMITER ;

SELECT TSTE_BVASE();

DELIMITER //

DROP PROCEDURE simpleSample //

CREATE PROCEDURE simpleSample (OUT param1 INT)
BEGIN
   SELECT COUNT(COLUMN_NAME) INTO param1 FROM INFORMATION_SCHEMA.COLUMNS LIMIT 1;
END//

DELIMITER ;

CALL simpleSample(@a);

SELECT @a;