sqlite3_vtab_nochange()

If the sqlite3_vtab_nochange(X) routine is called within the xColumn method of a virtual table, then it might return true if the column is being fetched as part of an UPDATE operation during which the column value will not change ... 

 ... UPDATE FROM The UPDATE-FROM idea is an extension to SQL that allows an UPDATE statement to be driven by other tables in the database. The "target" table is the specific table that is being updated. With UPDATE-FROM you ... 

sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()

 ... For an INSERT or UPDATE on a rowid table the seventh parameter is the final rowid value of the row being inserted or updated. The value of the seventh parameter passed to the callback function is not defined for operations ... 

sqlite3_update_hook()

The sqlite3_update_hook() interface registers a callback function with the database connection identified by the first argument to be invoked whenever a row is updated, inserted or deleted in a rowid table. Any callback set by a previous call to this ... 

 ... DELETE, INSERT, UPDATE. The trigger fires once for each row that is deleted, inserted, or updated. If the "UPDATE OF column-name" syntax is used, then the trigger will only fire if column-name appears on the left-hand side ... 

2.1. RBU Update Limitations The following limitations apply to RBU updates: The changes must consist of INSERT, UPDATE, and DELETE operations only. CREATE and DROP operations are not supported. INSERT statements may not use default values. UPDATE and DELETE statements must identify the target ... 

 ... The conflict resolution algorithm for the update operation of the DO UPDATE clause is always ABORT. In other words, the behavior is as if the DO UPDATE clause were actually written as "DO UPDATE OR ABORT". If the DO UPDATE ... 

sqlite3_changes(), sqlite3_changes64()

These functions return the number of rows modified, inserted or deleted by the most recently completed INSERT, UPDATE or DELETE statement on the database connection specified by the only parameter. The two functions are identical except for the type of ... 

Constraint Conflict Resolution in SQLite In most SQL databases, if you have a UNIQUE, NOT NULL, or CHECK constraint on a table and you try to do an UPDATE or INSERT that violates the constraint, the database will abort the ... 

 ... The special "*" expression expands into a list of all non-hidden columns of the table being deleted, inserted, or updated. For INSERT and UPDATE statements, references to columns in the table being modified refer to the value of that column ...