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
