What is the difference between commit and rollback in SQL?

What is the difference between commit and rollback in SQL?

In SQL, a 'commit' saves all changes made during the current transaction, while 'rollback' undoes those changes.

Can you give me an example of when to use rollback?

Sure! If you make a mistake while updating records, you can use rollback to revert to the previous state before the changes.

What happens if I forget to commit after making changes?

If you forget to commit, all your changes will be lost once the session ends or if a rollback is executed.

Are there any scenarios where I should avoid using commit?

Yes, avoid committing if you're unsure about the changes or if you need to validate them first. Always review before committing.