Transaction Management (BEGIN, COMMIT, ROLLBACK)

MagnumDB supports atomic multi-statement transactions guarded by Write-Ahead Logging and table locks.

transaction.sql

sql

BEGIN;

UPDATE accounts SET balance = balance - 50 WHERE id = 1;
UPDATE accounts SET balance = balance + 50 WHERE id = 2;

COMMIT;