GNU Info

(mysql.info)SET TRANSACTION

---

Prev: LOCK TABLES Up: Transactional Commands

---

Enter node , (file) or (file)node

`SET TRANSACTION' Syntax
------------------------

     SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL
     [READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE]

Sets the transaction isolation level for the global, whole session or
the next transaction.

The default behavior is to set the isolation level for the next (not
started) transaction.

If you set the `GLOBAL' privilege it will affect all new created
threads.  You will need the `PROCESS' privilege to do do this.

Setting the `SESSION' privilege will affect the following and all
future transactions.

You can set the default isolation level for `mysqld' with
`--transaction-isolation=...'. Note: Command-line options.