MySQL Forums
Forum List  »  General

Selecting columns from a MYSQL routine result
Posted by: Mike Berg
Date: June 11, 2012 06:00PM

I have a routine called sp_getalldata and I want to select only 2 columns col1 and col2 from the resultset of the routine.

I've tried

SELECT col1, col2 FROM (CALL sp_getalldata())

but it is invalid. What are my options?

Options: ReplyQuote


Subject
Written By
Posted
Selecting columns from a MYSQL routine result
June 11, 2012 06:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.