title: how to implement implicit row level locking in innodb?
body: <p>I'm using MySql(innodb storage engine). I want to implement row level implicit locking on update statement. so, that no other transaction can read or update that row concurrently.</p>
  
  <p>Example: 
  Transaction1 is executing
  <strong>"UPDATE Customers
  SET City='Hamburg'
  WHERE CustomerID=1;"</strong></p>
  
  <p>Then, at same time Transaction2 should not able to read or update same row but Transaction2 should be able to access other rows.</p>
  
  <p>Any help would be appreciated.
  Thank you for your time.</p>