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, 1835🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...