MySQL

How to use a user-defined function which generates result set in a SQL statement

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 15

Reputation: cy163 is an unknown quantity at this point

Solved Threads: 0

cy163

Offline

Newbie Poster

How to use a user-defined function which generates result set in a SQL statement

Oct 15th, 2008

Hello ALL,

I am new to MySQl. I am using MySQL ver 5.1.28
I have got two questions.
(1) Can I make a user-defined function return a tabular result.(say, a list of person name)

(2) Can I call the function in a select statement, like

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT * 
FROM 
        Employee_List LEFT JOIN Employee_WorkList 
    ON 
        Employee_List.Name = Employ_WorkList.Name 
WHERE 
        Employee_List.Name IN Tabular_Result_BY_UserFunction;
SELECT * 
FROM 
        Employee_List LEFT JOIN Employee_WorkList 
    ON 
        Employee_List.Name = Employ_WorkList.Name 
WHERE 
        Employee_List.Name IN Tabular_Result_BY_UserFunction;