Transaction Control Language in MySql

Transaction Control LanguageĀ statements are used to revoke transaction or to commit the data(they are basically what they mean and that is they control the transactions). What are the statements used with TCL

  • 1-Rollback(is used for revoking the transactions until last commit).
  • 2-Commit(is used to commit the transaction to the database, ! very important once the transaction is committed we cannot "rollback it " and once we rollback we cannot commit).
  • 3-Savepoint (identify a point in a transaction to which you can later roll back).
  • 4-Set transaction (Change transaction options like isolation level and what rollback segment to use).
We will look into TCL later on after we go thru our basic SQL knowledge; We also have :
  • -Session Control Statements.
  • -System Control Statement.
  • -Embedded SQL Statements.
But this are more advanced topics which we will discuss in the advanced tutorials .