What Is a Transaction

Q

What Is a Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback

✍: 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.

2007-05-11, 4508👍, 0💬