BEGIN

The SQL statement that starts a transaction, so the following statements form one unit.

In more detail

Without BEGIN, each statement is its own transaction and commits immediately. SQLite's BEGIN can be deferred, immediate or exclusive, which controls when it takes the lock that lets it write.

Example

In this course: a database test fixture can run BEGIN, hand the connection to the test and ROLLBACK afterwards.

Related terms

Taught in

References