CODEWITHSUNDEEP
mysqlsql
Bharathi
Bharathi

Reputation: 1545

How to return the table using mysql Function

I am using MySQL. I want to return the table using MySQL function. In SQL its working fine but not in MySQL. I attach my partial code

 DELIMITER $$

    CREATE FUNCTION myFunction() RETURNS @tmptable TABLE (item varchar(20))
    BEGIN  

        insert  into @tmptable(item) values('raja')     


        return
     END; $$

Upvotes: 13

Views: 45658

Answers (1)

Rahul Tripathi
Rahul Tripathi

Reputation: 172398

Using functions you can not return a table.

However you can use stored procedure to return the table.

 DELIMITER $$

 CREATE DEFINER=`root`@`%` PROCEDURE `sp_Name`(OUT po_ErrMessage   VARCHAR(200))
 BEGIN
 DECLARE EXIT HANDLER FOR SQLEXCEPTION
 BEGIN
SET po_ErrMessage = 'Error in procedure sp_Name';
 END;

 SELECT * FROM table_name;
END

Upvotes: 9

Related Questions