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|READONLY}BEG
- 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 | access_mo