Innodb row level locking

[niranjan joshi]

I am trying to update two different rows of same table at same time using two different transactions.Database engine type is InnoDB.i.e.I try to emulate row level locking.Is it possible to do the same?

My sample code:-

Transaction A starts first:-
mysql>start transaction;
mysql>begin;
mysql>select * from table1 where id=01 for update;

Transaction A is not yet commited....

Transaction B starts before A is commited...
mysql>start transaction;
mysql>begin;
mysql>update table1 set name='somename' where id=05

table1 have index on id field.

I expect transaction B will also continue to work but when i run above statements using two different mysql clients transaction B waits
for transaction A to finish so i am not getting effect which i want.

is i am forgetting something to do? or my undestanding of row locking is not correct?
I am using mysql version 5.0.51a.


Plz Replay.
Thank you.