Hey Everyone,

I created a stored procedure in MySQL that returns one resultset. Was curious if there was a way to SELECT these results into a table or temp table.

For example: CREATE TEMPORARY TABLE test (SELECT * FROM (CALL stored_proc))

That doesn't actually work, but you get my point.

Ideas?

create a similar stored proc that saves the data rather than returning it