-- 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') ;
-- 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') ;
Comments
0 B
|👍
/👎