CREATE PROCEDURE

DELIMITER // CREATE PROCEDURE proc1() BEGIN SELECT * FROM test; END // DELIMITER ; 

----------------

CALL proc1(); 
____________________________
DELIMITER // CREATE PROCEDURE proc2(OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM test; END // DELIMITER ; 
---------------
CALL proc2(@a); SELECT @a as 'COUNT';
 
____________________________