MySQL Tutorials - Herong's Tutorial Examples - Version 4.20, by Dr. Herong Yang
What Is a Transaction?
This section describes what is a transaction, a sequence of executions of DML (Data Manipulation Language) statements to be treated as single unit.
What Is a Transaction? A transaction is a sequence of executions of SQL statements that can be treated as a single unit in which all data changes can be committed or cancelled as a whole.
Most database servers offer two transaction management modes:
Most database server supports the following statements for transaction management:
Last update: 2015.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
PHP Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
►Transaction Management and Isolation Levels
Transaction Management in MySQL
"Read Uncommitted" Isolation Level
"Read Committed" Isolation Level
"Repeatable Read" Isolation Level
Defining and Calling Stored Procedures