What are the differences between commit and rollback in databases?

What are the differences between commit and rollback in databases?

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

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

Sure! If you encounter an error during a transaction, you can use rollback to revert to the last committed state.

What happens if I forget to commit after making changes?

If you forget to commit, your changes will not be saved, and they will be lost once the session ends.

Are there any risks associated with using rollback?

Yes, frequent rollbacks can lead to data inconsistency if not managed properly, especially in multi-user environments.