From: Martijn Tonies
Date: August 8 2005 10:44am
Subject: Re: MySQL 5 and 'delimiter'
List-Archive: http://lists.mysql.com/mysql/187482
Message-Id: <025a01c59c06$22dfb430$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Gleb,

> Hello.
>
>
> Comments from:
>   http://bugs.mysql.com/bug.php?id=12344
>
> might be helpful.

Thanks. So it seems that it's only a command line statement.

Any idea why I get the error when executing the full CREATE
from a Delphi VCL component? Weird thing is, the procedure
is saved to the database.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> > I'm a bit puzzled about the DELIMITER statement.
> >
> > Is this a command-line SQL statement only, or is this actually processed
> > on the server?
> >
> > And if it's a command-line thingy only, shouldn't I be able to execute
> > something
> > like:
> > CREATE PROCEDURE P_AA()
> >  MODIFIES SQL DATA
> > begin
> > delete from v_test;
> > delete from v_test;
> > end
> >
> > Which, currently, returns an error like this:
> > mySQL 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 ';
> > CREATE PROCEDURE P_AA()
> >  MODIFIES SQL DATA
> > begin
> > delete f
> >
> >
> > Any idea?