SQL COMMIT command

In SQL, the commit command can be used to permanently save any transaction into the database.

 

About Commit command


More so, you use any SQL DML commands such as insert, update or delete, however, changes made by these commands are not permanent, until the current session is closed. Also, the changes made by these commands can be rolled back.

The commit command can be used to avoid that by marking the changes as permanent.

This can be done with the syntax shown below;

COMMIT;