CreateAndUseProcedure.sql

-- create and use procedure
DROP PROCEDURE IF EXISTS getArticle;
DELIMITER $$
CREATE PROCEDURE getArticle(p_article VARCHAR(100))
BEGIN
  SELECT * FROM intervention WHERE Code_article = p_article ;
END$$
DELIMITER ;
CALL getArticle('00069') ;