SQL · Transactions and integrity

lock rows

Locks selected rows until the transaction ends, preventing lost updates. PostgreSQL and MySQL.

sqlRunnable example sql course

Syntax

select … for update

Example

Open in the lab

-- PostgreSQL
-- SELECT * FROM lessons WHERE id = 1 FOR UPDATE;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.