MySQL Forums
Forum List  »  Memory Storage Engine

Innodb row locking
Posted by: niranjan joshi
Date: January 07, 2009 05:37AM

i am trying to update two different rows of same table using two different transactions.Is it possible?
sample code...

transaction A

mysql>start transaction;
mysql>begin;
mysql>select * from table1 where id=01 for update;


transaction B

mysql>start transaction;
mysql>begin;
mysql>update employee set name='something' where id=05;

I have index on id field
Plz Replay
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Innodb row locking
9072
January 07, 2009 05:37AM
5057
January 07, 2009 08:37PM


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.