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 transaction-safe tables (like InnoDB or BDB),
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.

If you want to disable autocommit mode for a single series of
statements, you can use the START TRANSACTION statement:
