migrating a stored procedure from mysql 5.0 to 5.1.37

Question

Hi,

I am trying to migrate my database from MYSQL 5.1.37 on my machine to MYSQL 5.0 on my hosting company. But the problem is, while I am able to migrate my tables I got errors when I try stored procedures.

Here is one which works fine on my machine.

DELIMITER $$

DROP PROCEDURE IF EXISTS `db986`.`sp_addUser`$$
CREATE DEFINER=`tse`@`%` PROCEDURE  `db986`.`sp_addUser`(_loginid varchar(45),_password varchar(45),_email varchar(45),_accountcreateddate date,_gender char(8))
BEGIN
insert into login (`loginid`,`password`,`email`,`accountcreateddate`,`gender`) values (_loginid,_password,_email,_accountcreateddate,_gender);
END $$

DELIMITER ;

I am not sure what should I have to fix to get it running on the hosting company, I am using 1and1 as my hosting server.

Any help.

Answer 1

hello,,

I just removed the begin and end key from the code and works fine. dont know why though.