Read consistency example
SQL
Easy
3 views
Problem Description
Inside one transaction, read the same row twice. Show the basic idea using SELECT statements.
Constraints
Isolation level depends
Official Solution
BEGIN; SELECT balance FROM Accounts WHERE acc_id=1; SELECT balance FROM Accounts WHERE acc_id=1; COMMIT;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!