Collections:
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.
⇒ Ways to Start a New Transaction in MySQL
⇐ Transaction Management: Commit or Rollback in MySQL
2017-08-03, 1818🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...