Most database management systems offer some form of transaction. Transactions are very useful when multiple commands need to be executed.
Transactions are a huge part of ecommerce. A transaction follows four simple properties known as ACID:
SQL provides the concept of transactions and follows these rules.
START TRANSACTION; DELETE FROM `Attendees` WHERE forename = "Jane";
If the transaction fails it is easy to reset the database to it's former state. This is done with a rollback.
SQL provides an easy way to do this using the
A rollback will set the database back to the exact way it was before the transaction took place.