8.46. 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