MySQL Forums
Forum List  »  Italian

mysql 5.5 errore nella creazione di una stored procedure 1064
Posted by: marco pilolli
Date: October 19, 2010 02:46AM

quando ho cerco di creare una SP, con mysql 5.5, ho il seguente errore

Query : CREATE DEFINER=`root`@`%` PROCEDURE `glInsertsp`(IN inRifUser VARCHAR (30),IN inCreator VARCHAR (30)) BEGIN DECLARE dlnumrows S...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO dlnumrows FROM gldregistrazionicontabiliset WHERE RifUser=inRifUser AND set' at line 20

piĆ¹ o meno qui
DECLARE dlnumrows SMALLINT DEFAULT 0;
SELECT COUNT(RecId) INTO dlnumrows FROM tabelladaesaminare WHERE
RifUser=inRifUser;

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 5.5 errore nella creazione di una stored procedure 1064
2985
October 19, 2010 02:46AM


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.