MySQL Forums :: Newbie :: create function help


Advanced Search

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)
READS SQL DATA
BEGIN

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;

END

Options: ReplyQuote


Subject Written By Posted
create function help Todd Woolums 03/04/2009 10:20AM
Re: create function help Lee Wood 03/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.