MySQL Transaction 24 codes

1 Cancel the transaction by issuing a ROLLBACK statement

2 Create a savepoint with a name

3 Get lock

4 Is lock free

5 Is used lock

6 Issue a BEGIN statement to suspend auto-commit mode, then issue the queries that make up the transaction

7 Locking Syntax

8 MySQL provides the @@autocommit system variable that allows you to view the current autocommit mode setting

9 Performing a Transaction

10 Release lock

11 ROLL Back to the save point

12 Rollback work

13 Setting the Transaction Isolation Level

14 Start a TRANSACTION

15 Statements That Automatically Commit Transactions

16 The following SET statement sets the autocommit mode to off

17 The ROLLBACK Statement

18 The ROLLBACK TO SAVEPOINT Statement

19 TRANSACTION and ROLLBACK

20 TRANSACTION and save point

21 Turn the autocommit mode back on

22 User transaction in table

23 Using the SET TRANSACTION Statement

24 Using TRANSACTION and COMMIT