The affairs of 12-sqlite

I. Overview of the transaction

A transaction is a series of operations performed as a single logical unit. Multiple operations are submitted to the system as a whole, either executed or not executed, and the transaction is an inseparable unit of work logic.

II. implementation of the transaction

Begin: Start a transaction

Rollback: Rolling back a transaction

Commit: Commit a transaction

Note: What does "rollback TRANSACTION" mean?

Suppose 1: I now execute the 5 SQL Statements of begin, A, B, C, rollback in turn, and return to the begin position when rollback transactions are encountered, meaning that A, B, c three statements do not work

Suppose 2: I now execute the 5 SQL statements of Begin, A, B, C, and commit in turn, confirming that A, B, and C are executed when a commit transaction is encountered

The affairs of 12-sqlite