MySQL 事务中发生错误，事务真的会回滚吗

Question

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

如图，开启事务，第二条SQL发生错误，COMMIT之后发现第一条SQL并没有"回滚"。

MySQL 5.7
存储引擎InnoDB

在MySQL文档中发现这么一句话

InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction.
https://dev.mysql.com/doc/ref...

如何理解上述现象？

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

449 views

1 Answer

深蓝 · Answer 1 · 2021-01-29T04:20:30+0000

answered Jan 29, 2021 by 深蓝 (71.8m points)

因为你手动commit了事务，会把成功的sql执行

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…