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, 3767🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...