PDA

View Full Version : CREATE PROCEDURE Error



reagan83
09-01-2006, 12:19 PM
I'm getting an error when trying to create a procedure on my database.

select version();
Returns: 5.0.24-standard-log

Error:
MySQL said:

#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 'DELIMITER $$

CREATE PROCEDURE `ActivateAccount`(
AccountID int,
AccountPass' at line 1

My code (which works on my local dev machine):
DELIMITER $$

CREATE PROCEDURE `ActivateAccount`(
AccountID int,
AccountPassword varchar(100)
)
Begin

UPDATE Users SET Enabled = true, `Password` = AccountPassword WHERE UserID = AccountID;

End $$


DELIMITER ;

Any thoughts?