What Is a Transaction - Unit of Work in MySQL


What Is a Transaction in MySQL?

✍: FYIcenter.com


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.


Transaction Management: Commit or Rollback in MySQL

⇒⇒MySQL Database Tutorials

2017-08-03, 973👍, 0💬