From: Martijn Tonies
Date: April 5 2004 3:49pm
Subject: Re: Create my First Stored Procedure ...
List-Archive: http://lists.mysql.com/mysql/163092
Message-Id: <05b701c41b25$9e611940$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> Help Me!!
> I must create this simple stored procedure :

You might want to read some documentation on this...
http://www.mysql.com/doc/en/Stored_Procedures.html

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

select count(*) into param1 from clz.articoli;

> 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 ??

And make sure to set the statement delimiter.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com