title: How to return the table using mysql Function
body: <p>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</p>
  
  <pre><code> DELIMITER $$
  
      CREATE FUNCTION myFunction() RETURNS @tmptable TABLE (item varchar(20))
      BEGIN  
  
          insert  into @tmptable(item) values('raja')     
  
  
          return
       END; $$
  </code></pre>