[SOLVED] MySQL function/routine problem

[BloodyMind]

I have this function working on my localhost: running perfectly

CREATE DEFINER=`MYUSERNAME`@`localhost` FUNCTION `member_networth`(`member_id` double) RETURNS double
BEGIN
DECLARE networth DOUBLE;
SELECT total_net_worth INTO networth FROM member_balance mb WHERE mb.member_id=member_id ORDER BY balance_date DESC LIMIT 1 ;
RETURN networth;
END

 

When I tried to import it on the server or write this SQL into PMA on the server

I doesn't work giving me the following error:

SQL query:

CREATE DEFINER = `MYUSERNAME`@`localhost` FUNCTION `member_networth` (
`member_id` double
) RETURNS double BEGIN DECLARE networth DOUBLE;

MySQL said: Documentation
#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 '' at line 3 

 

any help will be appreciated

 

[fenway]

Sounds like you didn't switch your delimeter.

[BloodyMind]

Thank you very much. You saved the rest of my day.