MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: SELECT ... FOR UPDATE in a Transaction
Posted by: KimSeong Loh
Date: March 02, 2008 06:18PM

The lock should be enforce within the transaction. The BEGIN sort of turn off AUTOCOMMIT until you complete the transaction.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SELECT ... FOR UPDATE in a Transaction
5249
Vítězslav Plachý
March 02, 2008 12:20PM
Re: SELECT ... FOR UPDATE in a Transaction
2172
KimSeong Loh
March 02, 2008 06:18PM
Re: SELECT ... FOR UPDATE in a Transaction
2005
Vítězslav Plachý
March 03, 2008 01:38PM
Re: SELECT ... FOR UPDATE in a Transaction
1894
KimSeong Loh
March 03, 2008 05:15PM
Re: SELECT ... FOR UPDATE in a Transaction
1800
david yeung
March 06, 2008 02:03AM


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.