MySQL Forums
Forum List  »  Stored Procedures

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

and what shoud I take?
READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

as manual says [ http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html ] i must use *select for update* no matter what mode you use

Options: ReplyQuote


Subject
Views
Written By
Posted
5580
September 24, 2012 02:37AM
2154
September 28, 2012 01:35PM
Re: table locks in cursor. how it works?
1408
October 04, 2012 12:12AM


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.