Re: why DELIMITER $$

[Roland Bouman]

Hi,

[I don't think '123' is a valid identifier. Try prefixing it with a letter]

How funny! Look what happens when i paste that:

mysql> delimiter go
mysql> create procedure 123()
-> begin
-> end
-> go
ERROR 1064 (42000): 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 '123()

begin
end' at line 1
mysql> ;
->

You see, my

delimiter go

is processed, you can tell because the next line starts with a mysql> prompt. In your case, the delimiter command does not seem to be processed at all.
Because it is processed in my case, the 'go' after the end delimits the proc, and the mysql gives us an error due to the invalid procname (when i make it a valid name, the proc is created).

I am at a total loss as to why your mysql command line client does not process the delimiter command.

Have you tried this in the query browser?