What Is a Transaction - Unit of Work in MySQL

Q

What Is a Transaction in MySQL?

✍: FYIcenter.com

A

A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

The transaction concept only works on tables that use transaction-safe storage engines, like InnoDB and BDB. For transaction-unsafe storage engines, like MyISAM, transaction will be ignored.

⇒ Ways to Start a New Transaction in MySQL

⇐ Transaction Management: Commit or Rollback in MySQL

⇑ Transaction Management: Commit or Rollback in MySQL

⇑⇑ MySQL Database Tutorials

2017-08-03, 3414🔥, 0💬