Create Procedure In MYSQL

The following example shows a simple stored procedure that uses an OUT parameter:

delimiter //
CREATE PROCEDURE simpleproc (OUT param1 INT)
BEGIN
SELECT COUNT(*) INTO param1 FROM t;
END//
delimiter ;

And the below command use to call the above procedure :

CALL simpleproc(@a);