Can a stored procedure/function return a table?

by

As for now, this is not possible.

Here is the documentation on what may be used in the FROM clause:

table_references:
    table_reference [, table_reference] ...

table_reference:
    table_factor
  | join_table

table_factor:
    tbl_name [[AS] alias] [index_hint)]
  | table_subquery [AS] alias
  | ( table_references )
  | { OJ table_reference LEFT OUTER JOIN table_reference
        ON conditional_expr }

join_table:
    table_reference [INNER | CROSS] JOIN table_factor [join_condition]
  | table_reference STRAIGHT_JOIN table_factor
  | table_reference STRAIGHT_JOIN table_factor ON conditional_expr
  | table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_condition
  | table_reference NATURAL [{LEFT|RIGHT} [OUTER]] JOIN table_factor

join_condition:
    ON conditional_expr
  | USING (column_list)

index_hint:
    USE {INDEX|KEY} [FOR JOIN] (index_list)
  | IGNORE {INDEX|KEY} [FOR JOIN] (index_list)
  | FORCE {INDEX|KEY} [FOR JOIN] (index_list)

index_list:
    index_name [, index_name] ...

As you can see, stored procedures are not in this list.

More Related Contents:

  1. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  2. Is it possible to have a default parameter for a mysql stored procedure?
  3. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  4. Join vs. sub-query
  5. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  6. Natural Sort in MySQL
  7. MySQL get row position in ORDER BY
  8. Subqueries vs joins
  9. Can I pass column name as input parameter in SQL stored Procedure
  10. MySQL Results as comma separated list
  11. MySQL unknown column in ON clause
  12. Connect By Prior Equivalent for MySQL
  13. Stored procedure or function expects parameter which is not supplied
  14. MySQL not using indexes with WHERE IN clause?
  15. SQL: Find the max record per group [duplicate]
  16. Group by month and year in MySQL
  17. MySQL: Transactions vs Locking Tables
  18. Remove duplicates using only a MySQL query?
  19. Group by date only on a Datetime column
  20. Which is better: Ad hoc queries or stored procedures? [closed]
  21. Finding the next available id in MySQL
  22. Execute Immediate within a stored procedure keeps giving insufficient priviliges error
  23. MySQL select where column is not empty
  24. Hamming distance on binary strings in SQL
  25. Renaming foreign-key columns in MySQL
  26. MySQL GROUP BY behavior
  27. Update multiple rows with one query?
  28. Bulk insert using stored procedure
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment