MySQL Forums
Forum List  »  Newbie

create function help
Posted by: Todd Woolums
Date: March 04, 2009 10:20AM

New to mysql functions and looking for some help. Here is what I have but it keeps saying I have a syntax error. Sql statement works as I would expect just can't get the function to work.

CREATE FUNCTION `getApplications`(server_id int(25))
RETURNS varchar(255)

SELECT group_concat(name) INTO applications
FROM application a,application_server_join asj
WHERE a.application_id =asj.application_id and asj.server_id = server_id;
RETURN applications;


Options: ReplyQuote

Written By
create function help
March 04, 2009 10:20AM
March 04, 2009 10:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.