Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to return records set from SP (SF) in v5.0?

Status
Not open for further replies.
alebu

alebu

Programmer
Sep 7, 2002
46
Hi, i have stored procedure (or function) and I need to return records set from it. This result set is generated inside SP, so simple select <some columns> from <somewhere> will not work. In postgresql this is done using SET OF construction, but how to do it in MySQL?
 
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
282
spamjim
spamjim
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
208
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
257
EdLentz
EdLentz
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
171
jg2828
jg2828
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
231
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top