Re: mysql 5.0.10 stored procedure

[Jay Pipes]

you need to explicitly set the delimiter to something other than ; before executing. Otherwise, MySQL thinks you're ending the procedure at the ;.

from mysql client:

mysql> DELIMITER //
mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
> BEGIN
> SELECT COUNT(*) INTO param1 FROM admin_profile;
> END //
mysql> DELIMITER ;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com