create procedure problems

[duncan campbell]

Howdy?

I'm having problems with mysql 4.1.9 and the command line interpreter.

Attempting to created a procedure, I do as follows:

mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t; END//
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 'PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t; ' at line 1

Any help would be appreciated.

If mysql4 doesn't support this functionality, is it possible to use if(,,) to do a conditional insert?

Thanks,

Dhu