MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Not locking....
Posted by: Lalit Shakya
Date: October 04, 2008 06:03AM

The row label locking is done in this way


SELECT * FROM tablename WHERE id=vale FOR UPDATE;

Please keep in mind id field must be index please check this may be problem second


http://dev.mysql.com/doc/refman/5.0/en/innodb-next-key-locking.html

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


Subject
Views
Written By
Posted
Not locking....
2987
Arend Jan Zwart
September 22, 2008 01:34AM
Re: Not locking....
1673
KimSeong Loh
September 28, 2008 08:27PM
Re: Not locking....
1687
Arend Jan Zwart
September 29, 2008 05:03AM
Re: Not locking....
1648
KimSeong Loh
September 29, 2008 06:53PM
Re: Not locking....
1648
Lalit Shakya
October 04, 2008 06:03AM
Re: Not locking....
1556
Lalit Shakya
September 28, 2008 10:09PM


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.