2.5. Statement Journal Files  ... For example, suppose an UPDATE statement will attempt to modify 100 rows in the database. But after modifying the first 50 rows, the UPDATE hits a constraint violation which should block the entire statement. The statement journal is used to ... 

sqlite3_blob_open()

 ... If the row that a BLOB handle points to is modified by an UPDATE, DELETE, or by ON CONFLICT side-effects then the BLOB handle is marked as "expired". This is true if any column of the row is changed ... 

 ... JSON functions keywords math functions ON CONFLICT clause PRAGMA REINDEX RELEASE SAVEPOINT REPLACE RETURNING clause ROLLBACK TRANSACTION SAVEPOINT SELECT UPDATE UPSERT VACUUM window functions WITH clause The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list ... 

2.2. Truncating A Database Normally the data for UPDATE and INSERT must be a blob which is the exact same size as a database page. However, as a special case, doing an INSERT of a NULL into page 2 or greater as the last ... 

3. The AUTOINCREMENT Keyword  ... A row in the sqlite_sequence table corresponding to the table with the AUTOINCREMENT column is created the first time the AUTOINCREMENT table is written and updated on any subsequent writes that increase the maximum rowid. The content of the sqlite_sequence ... 

sqlite3_total_changes(), sqlite3_total_changes64()

These functions return the total number of rows inserted, modified or deleted by all INSERT, UPDATE or DELETE statements completed since the database connection was opened, including those executed as part of trigger programs. The two functions are identical except ... 

 ... UNION ALL, INTERSECT, and EXCEPT A rich library of standard SQL functions Aggregate functions including DISTINCT aggregates Window functions UPDATE, DELETE, and INSERT (of course) Common table expressions including recursive common table expressions Row values UPSERT An advanced query planner ... 

sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ... 

 ... Within the xUpdate method of a virtual table, the sqlite3_value_nochange(X) interface returns true if and only if the column corresponding to X is unchanged by the UPDATE operation that the xUpdate method call was invoked to implement and if ... 

sqlite3_progress_handler()

 ... An example use for this interface is to keep a GUI updated during a large query. The parameter P is passed through as the only parameter to the callback function X. The parameter N is the approximate number of virtual ... 

sqlite3_is_interrupted()

 ... If the interrupted SQL operation is an INSERT, UPDATE, or DELETE that is inside an explicit transaction, then the entire transaction will be rolled back automatically. The sqlite3_interrupt(D) call is in effect until all currently running SQL statements on ...