Re: Importare stored procedure in PhpMyAdmin

[Danut Prisacaru]

The DELIMITER needs to be made out of only one character so if you write your code like below it will work:

DROP PROCEDURE IF EXISTS `qCaricaAziendaDaArticolo`;
DELIMITER $
CREATE PROCEDURE `qCaricaAziendaDaArticolo`(IN idArticolo INT)
BEGIN
SELECT AZ.*
FROM tblAnagraficaAziende AZ
INNER JOIN tblArticoli AR ON AR.idAzienda = AZ.ID
WHERE AR.ID = idArticolo;
END $
DELIMITER ;