MySQL Forums
Forum List  »  Stored Procedures

Re: dynamically alloc cursur vs. local,gloab cursor
Posted by: Rick James
Date: August 02, 2016 06:38PM

When I here of someone asking about SQL Cursors, I envision a programmer who has not learned the power of SQL.

Most (not all) uses of Cursors can be eliminated by formulating a single SQL that does all the work "all at once" rather than iterating through code.

If you would like to show use the SQL loop, and SHOW CREATE TABLE, we may be able to help you make it better -- thereby obviating the questions you posed.

Options: ReplyQuote

Written By
Re: dynamically alloc cursur vs. local,gloab cursor
August 02, 2016 06:38PM

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.