START TRANSACTION, LOCK, SAVEPOINT, ISOLATION
-
ISOLATION
Syntax: SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL { READ ... -
LOCK
Syntax: LOCK TABLES tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_t -
SAVEPOINT
Syntax: SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELE... -
START TRANSACTION
Syntax: START TRANSACTION [WITH CONSISTENT SNAPSHOT] | BEGIN [WORK] COMMIT [WORK] [AND [NO]