use result set of mysql stored procedure in another stored procedure
Posted
by hmak
on Stack Overflow
See other posts from Stack Overflow
or by hmak
Published on 2010-03-17T23:45:56Z
Indexed on
2010/03/17
23:51 UTC
Read the original article
Hit count: 522
mysql
|stored-procedures
I have a MYSQL stored procedure SP1() that returns a result set.
I want to call SP1() inside of SP2() and loop through the result set of SP1() to do some additional work.
I don't want to include my logic from SP1() because it would make SP2() too complicated.
Any suggestions?
Thanks.
© Stack Overflow or respective owner