List:General Discussion« Previous MessageNext Message »
From:s.mirco Date:April 5 2004 3:19pm
Subject:Create my First Stored Procedure ...
View as plain text  
Hello,
Help Me!!
I must create this simple stored procedure :

create procedure simpleproc (out param1 INT)
begin
select count(*) from clz.articoli;
end;

I use MySql Control Center Editor and database MySql 5.0.0-alpha-max-nt
 for compile this procedure!

this is the error:
[root] ERROR 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
..
where is the problem ??

I'm a novice developer!!!
Best Regards

Mirco




__________________________________________________________________
Social price: l'ADSL diventa per tutti
Tiscali ADSL Senza Canone 640Kbps: GRATIS fino al 15 aprile costo
di adesione, attivazione e il modem per tutto il 2004. E per i primi 3 mesi,
con il Tiscali social price, navighi a 1,5 euro l'ora! Affrettati!
http://point.tiscali.it/adsl/prodotti/640Kbps/



Thread
Create my First Stored Procedure ...s.mirco5 Apr
  • Re: Create my First Stored Procedure ...Martijn Tonies5 Apr