Syntax:
START TRANSACTION | BEGIN [WORK]
COMMIT
ROLLBACK

The START TRANSACTION and BEGIN statement begin a new transaction.
COMMIT commits the current transaction, making its changes permanent.
ROLLBACK rolls back the current transaction, canceling its changes. The
mode for the current connection.

By default, MySQL runs with autocommit mode enabled. This means that as
soon as you execute a statement that updates (modifies) a table, MySQL
stores the update on disk.

If you are using a transaction-safe storage engine (such as InnoDB,
BDB, or NDB Cluster), you can disable autocommit mode with the
following statement:


After disabling autocommit mode by setting the AUTOCOMMIT variable to
zero, you must use COMMIT to store your changes to disk or ROLLBACK if
you want to ignore the changes you have made since the beginning of
your transaction.

To disable autocommit mode for a single series of statements, use the
START TRANSACTION statement:
