... For a JOIN or INNER JOIN or CROSS JOIN, there is no difference between a constraint expression in the WHERE clause and one in the ON clause. However, for a LEFT or RIGHT or FULL OUTER JOIN, the difference is ... 

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 ... 

3.3. Inspecting the Contents of a Changeset  ... Additionally, the same API can be used to obtain the name of the table the change applies to and its expected number of columns and primary key columns. If the iterator points to a valid INSERT or UPDATE entry, the ... 

3. Interpretation Of The Schema Table  ... rootpage The sqlite_schema.rootpage column stores the page number of the root b-tree page for tables and indexes. For rows that define views, triggers, and virtual tables, the rootpage column is 0 or NULL. sql The sqlite_schema.sql column ... 

2. Interface Details  ... The pointer can be used to pass application-specific setup or state information, if desired. Or it can simply be a NULL pointer which is ignored by the callback. The second argument to the error logger callback is an integer ... 

6. Binding Parameters and Reusing Prepared Statements  ... These values can later be changed and the same prepared statement can be evaluated a second time using the new values. SQLite allows a parameter wherever a string literal, blob literal, numeric constant, or NULL is allowed in queries or ... 

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

 ... The N parameter must be between 0 and one less than the number of columns or the behavior will be undefined. This must only be used within SQLITE_UPDATE and SQLITE_DELETE preupdate callbacks; if it is used by an SQLITE_INSERT callback ... 

 ... Make sure that database filenames follow the 8+3 filename format and that they do not have an empty name or extension. In other words, the database filename must contain between 1 and 8 characters in the base name and ... 

 ... The SQLite Encryption Extension (SEE), the ZIPVFS Extension, and the Compressed and Encrypted ReadOnly Database (CEROD) extension are enhanced versions of SQLite that handle encrypted and/or compressed databases. SEE can read and write encrypted databases. SEE encrypts all database ... 

sqlite3_changes(), sqlite3_changes64()

 ... The two functions are identical except for the type of the return value and that if the number of rows modified by the most recent INSERT, UPDATE, or DELETE is greater than the maximum value supported by type "int", then ...