✅ COMMIT Command in SQL

Last Updated: January 2026

The COMMIT command is a TCL (Transaction Control Language) command used to permanently save all changes made in the current transaction.

👉 Once committed, changes cannot be undone.

  • Saves INSERT, UPDATE, DELETE changes
  • Ends the current transaction
  • Makes changes visible to other users
  • Clears all savepoints

Hinglish Tip 🗣: Jab changes final ho jaayein aur permanently save karne ho, tab COMMIT use hota hai.

Basic COMMIT

Syntax

COMMIT;

COMMIT with DML

START TRANSACTION;

INSERT INTO employees VALUES (1, 'Amit', 50000);
UPDATE employees SET salary = 55000 WHERE emp_id = 1;

COMMIT;

After COMMIT:

  • Data is permanently stored
  • ROLLBACK will not work for these changes
← PreviousNext →