Create
DELIMITER $$
CREATE PROCEDURE <procedure>(IN <variable> <type>, OUT <variable> <type>)
BEGIN
<statement>;
END $$
DELIMITER ;Call
CALL <procedure>(<value>, @<variable>);Drop
DROP PROCEDURE IF EXISTS <procedure>;DELIMITER $$
CREATE PROCEDURE <procedure>(IN <variable> <type>, OUT <variable> <type>)
BEGIN
<statement>;
END $$
DELIMITER ;CALL <procedure>(<value>, @<variable>);DROP PROCEDURE IF EXISTS <procedure>;