Hello.
Comments from: http://bugs.mysql.com/bug.php?id=12344 might be helpful. "Martijn Tonies" <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
