96. What is start transaction commit & roll back transaction & how to use them? wht do you mean by roll back transaction?

 These statements provide control over use of transactions

START TRANSACTION or BEGIN start a new transaction.

COMMIT - commits the current transaction, making its changes permanent.

ROLLBACK - rolls back the current transaction, canceling its changes.

ROLLBACK TRANSACTION rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction. It also frees resources held by the transaction