List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 8 2005 9:48am
Subject:Re: MySQL 5 and 'delimiter'
View as plain text  
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



Thread
MySQL 5 and 'delimiter'Martijn Tonies8 Aug
  • Re: MySQL 5 and 'delimiter'Gleb Paharenko8 Aug
  • Re: MySQL 5 and 'delimiter'Martijn Tonies8 Aug
    • Re: MySQL 5 and 'delimiter'Gleb Paharenko8 Aug
  • Re: MySQL 5 and 'delimiter'Martijn Tonies8 Aug