MySQL Forums
Forum List  »  Stored Procedures

Re: table locks in cursor. how it works?
Posted by: Yurii Korotia
Date: October 02, 2012 12:45AM

good morning

what do you mean under " notable mistake" ?

I cannot use just select, because query is built dynamically, and cursor cannot be openned on prepared statements. So, on forum I found 2 solutions - create view or temporary table. As view is aster and operates with real data I went with view.

situation requires granular update - row by row. It is not possible to make bulk update.

Options: ReplyQuote


Subject
Views
Written By
Posted
5579
September 24, 2012 02:37AM
2153
September 28, 2012 01:35PM
Re: table locks in cursor. how it works?
1384
October 02, 2012 12:45AM


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.