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?
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?