How to use Table output from stored MYSQL Procedure
This can’t be done, directly, because the output of an unbounded select in a stored procedure is a result set sent to the client, but not technically a table. The workaround is to let the proc put the data in a temporary table after creating the table for you. This table will be available only … Read more