Prevent concurrent modifications to matched rows inside a transaction.
Section: locking and concurrency
Lock selected rows for update
sql
sql
SELECT * FROM accounts WHERE id = 1 FOR UPDATE;Explanation
Common in balance transfers, inventory reservations, and queue consumers.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing locking and concurrency
Lock rows for shared reads
Read rows while protecting against conflicting writes.
Set transaction isolation level
Control read consistency and concurrency behavior.
Inspect InnoDB lock and transaction state
Display detailed InnoDB diagnostics.
Set lock wait timeout for the session
Avoid waiting too long on blocked locks.