MySQL Forums
Forum List  »  Italian

Re: Importare stored procedure in PhpMyAdmin
Posted by: Danut Prisacaru
Date: February 13, 2009 06:16PM

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 ;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Importare stored procedure in PhpMyAdmin
4351
February 13, 2009 06:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.