MySQL支持通过语句，如本地事务（一个给定的客户端会话内）SET autocommit，START TRANSACTION，COMMIT，和ROLLBACK。请参见“ START TRANSACTION，COMMIT和ROLLBACK语句”。XA事务支持使MySQL也可以参与分布式事务。请参见“ XA事务”。
事务处理
- START TRANSACTION，COMMIT和ROLLBACK语句
- STARTTRANSACTION [transaction_characteristic [, transaction_characteristic] ...]transaction_characteristic: { WITHCONSISTENTSNAPSHOT|READWRITE|READONL
- SAVEPOINT， ROLLBACK TO SAVEPOINT 和 RELEASE SAVEPOINT
- SAVEPOINT identifierROLLBACK [WORK] TO [SAVEPOINT] identifierRELEASESAVEPOINT identifierInnoDB支持SQL语句SAVEPOINT，ROLLBACK TO SAVEPOINT，RELEASE SAVEPOINT
- BACK和LOCK INSTANCE语句的锁定实例
- LOCKINSTANCEFORBACKUPUNLOCKINSTANCELOCK INSTANCE FOR BACKUP获取实例级别的备份锁，该锁在联机备份期间允许DML，同时防止可能导致快照不一致的操作。执行该LOCK INSTANCE FOR BACKUP语句需要BACKUP_ADMIN特权。当执
- LOCK TABLES 和 UNLOCK TABLES 语句
- LOCKTABLES tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE}UNLOCKTABLESMySQL使客
- SET TRANSACTION语句
- SET [GLOBAL|SESSION] TRANSACTION transaction_characteristic [, transaction_characteristic] ...transaction_characteristic: { ISOLATIONLEVEL level | acc