START TRANSACTION

Synopsis

1. START TRANSACTION [ mode [, ...] ]

where mode is one of

1. ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE }
2. READ { ONLY | WRITE }

Description

Start a new transaction for the current session.

Examples

1. START TRANSACTION;
2. START TRANSACTION ISOLATION LEVEL REPEATABLE READ;
3. START TRANSACTION READ WRITE;
4. START TRANSACTION ISOLATION LEVEL READ COMMITTED, READ ONLY;
5. START TRANSACTION READ WRITE, ISOLATION LEVEL SERIALIZABLE;

See Also

COMMIT, ROLLBACK