Introduction

The SQL START TRANSACTION statement is used to start a transaction on the current database.

Syntax

START TRANSACTION
[WITH <comma-separated list of tables>]

Use the START TRANSACTION statement to start a transaction. The WITH clause allows to start a restricted transaction on a specified set of tables. It accepts a comma-delimited list of table names to include in the restricted transaction.