Hello.
Comments from:
http://bugs.mysql.com/bug.php?id=12344
might be helpful.
"Martijn Tonies" <m.tonies@stripped> wrote:
> Hi there,
>
> 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?
>
>
> 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
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
