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

In other subjects