COMMIT
noun
say it: “kuh-MIT” /kəˈmɪt/
The SQL statement that ends a transaction and saves all its changes for good.
What does COMMIT do in a relational database?
COMMIT — A statement that successfully ends a transaction and makes its changes durable.
START TRANSACTION;
UPDATE account
SET balance = balance - 50
WHERE account_id = 1;
COMMIT;
In a sentence
- “Both updates worked, so I ran COMMIT to save them.”
Level: Journeyman · More SQL terms at this level
Updated