Innodb row locking

[niranjan joshi]

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