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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
