Partially Rolling Back a Transaction in MySQL or PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None” […]
本文讨论了数据库事务控制行为和回滚到特定点的功能。ACID兼容的关系型数据库遵循“全部或无”的概念,出错时会回滚并不会对数据库进行更改。保存点可以将事务回滚到特定点,帮助部分回滚。