commitLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

COMMIT and ROLLBACK

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

Transaction Control-TCL

statements are used to manage the changes made by DML statements Some Examples 1)COMMIT-save work done 2)SAVEPOINT-identify a point in a transaction to which you can later roll back 3)ROLLBACK-restore database to original since the last COMMIT 4)SETTRANSACTION- Change transaction options like isolation level and what rollback segment to use.