DELIMITER $$

CREATE PROCEDURE procedure_name(IN input_variable_name.... data-type,OUT output_variables... data-type)
BEGIN
      -- statements

END
$$

-- To see specific procedure source
SHOW CREATE PROCEDURE procedure_name;

-- To see all procedures
SHOW PROCEDURE STATUS;

-- To see all procedures in another way
SELECT * FROM `mysql`.`proc`;
SELECT * FROM `mysql`.`proc` WHERE db = 'database_name';

-- To see all procedures with filter
SHOW PROCEDURE STATUS WHERE Db = "database_name";

DROP PROCEDURE procedure_name;
Or
DROP PROCEDURE IF EXISTS procedure_name;