row lock

A database lock on one row that makes other transactions wait before changing it.

In more detail

Taking a row lock on read is the pessimistic guard against lost updates. Locks are released when the transaction commits or rolls back.

Related terms

Taught in

References