Start Transaction OR Begin Work

mysql percona
Motasem picture Motasem · May 5, 2012 · Viewed 7.7k times · Source

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

Answer

eggyal picture eggyal · May 5, 2012

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.

Related questions

mysql process cannot be stopped

I have recently installed 5.5.28-29.2 Percona Server (GPL), Release 29.2 in a Ubuntu 12.04 OS Desktop. I have tried to stop the server using different methods: - sudo /etc/init.d/mysql stop - sudo kill -9 pid - mysqladmin -u root …

Read More
COMMIT OR conn.setAutoCommit(true)

I have noticed some programmer using COMMIT other using conn.setAutoCommit(true); to end the transaction or roll back so what are the benefits of using one instead of the other? Where is the main difference? conn.setAutoCommit(true); over …

Read More
MySQL Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'

MySQL (Percona 5.6) will not start. This error has happened to me several times. Each time, I have had to remove MySQL data directories and reinstall MySQL. Is there another way to fix MySQL? (Specifically one in which the data not …

Read More