IntroductionThe 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 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.
Please see the Transactions topic for more information on transactions.