I subscribed to the list after the thread with the abovementioned subject
was started, and I don't see any way to reply to it using the web browser,
so I'm posting with "Re:" prepended to the subject.
Vishal Mathur writes that he can not use the delimiter statement, using 5.0
on win2k professional. Since I also use that same OS, I thought I'd try
his procedure:
C:\>mysql -u rdo
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc(out param1 int)
-> BEGIN
-> select count(*) into param1 from lca_lookups;
-> END;
-> //
Query OK, 0 rows affected (0.11 sec)
mysql> delimiter ;
Since it appears to compile ok here, delimiter statement and all, I don't
know what to say. What server are you using - mysqld, or mysqld-nt?
