COMMIT and ROLLBACK

By | December 7, 2013

Commit and Rollback mainly used in mysql transactions.

Commit: when a successful transaction is completed the commit command should be issued so that the changes to all involved tables will take effect.

Rollback:if a failure occurs, a Rollback command should be issued to return every table referenced in the transaction to its previous state