目录
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)