START TRANSACTION, COMMIT, and ROLLBACK Syntax
  1. START TRANSACTION
  2. [transaction_characteristic [, transaction_characteristic] ...]
  3. transaction_characteristic:
  4. WITH CONSISTENT SNAPSHOT
  5. | READ WRITE
  6. | READ ONLY
  7. BEGIN [WORK]
  8. COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
  9. ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
  10. SET autocommit = {0 | 1}