事务的四大特性

目录

1.Mysql日志

2.事务的四大特性

2.1 原子性(Atomic)

2.2 持久性(Durability)

2.3 一致性(Consistency)

2.4 隔离性(Isolation)

---

1.Mysql日志

注：DDL和DML,详细可见MySQL数据库（一）_诺言的博客-CSDN博客

2.事务的四大特性

/*事务的基本操作*/
START TRANSACTION
   [transaction_characteristic [, transaction_characteristic] ...]
transaction_characteristic: {
   WITH CONSISTENT SNAPSHOT
 | READ WRITE
 | READ ONLY
}
BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET autocommit = {0 | 1}

2.1 原子性(Atomic)

2.2 持久性(Durability)

2.3 一致性(Consistency)

2.4 隔离性(Isolation)