Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
START TRANSACTION; -- Lock the row to prevent concurrent updates SELECT balance FROM accounts WHERE id = 1 FOR UPDATE; -- Now safely update UPDATE accounts SET balance = balance - 200 WHERE id = 1; COMMIT; -- Shared lock (read lock, blocks writes but not reads): SELECT * FROM products WHERE id = 10 FOR SHARE;
Result
Open