Search code examples
mysqlpercona

Start Transaction OR Begin Work


I don't know what is better to use Start Transaction OR Begin Work, and what is the difference.


Solution

  • From the MySQL manual:

    BEGIN and BEGIN WORK are supported as aliases of START TRANSACTION for initiating a transaction. START TRANSACTION is standard SQL syntax and is the recommended way to start an ad-hoc transaction.