2.1. Columns  ... This field is the number of rows that have been inserted into automatic indexes. A positive value in this field may indicate an opportunity to improve performance by adding a named index that take the place of the automatic index ... 

3. Flexible Typing  ... Thus, if one inserts '1234' into an INTEGER column, that value is converted into an integer 1234 and stored. But, if you insert a non-numeric string like 'wxyz' into an INTEGER column, unlike other SQL databases, SQLite does not ... 

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

 ... You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite. However, in many cases you can use an INSTEAD OF trigger on the view to accomplish the same thing. Views are removed with the DROP VIEW ... 

 ... CREATE TABLE x1(x INTEGER); INSERT INTO x1 VALUES(1); INSERT INTO x1 VALUES(2); INSERT INTO x1 VALUES(NULL); Given the definition of X1 above, the following expressions have historically evaluated to FALSE in SQLite, though the correct answer ... 

14.4. SQLite Archive Insert And Update Commands The --update and --insert commands work like --create command, except that they do not delete the current archive before commencing. New versions of files silently replace existing files with the same names, but otherwise the initial contents of the archive ... 

1.1. Lemon Source Files And Documentation  ... The "lemon" utility program reads this template and inserts additional code in order to generate a parser.

SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ... 

 ... SQLITE_STMTSTATUS_AUTOINDEX This is the number of rows inserted into transient indices that were created automatically in order to help joins run faster. A non-zero value in this counter may indicate an opportunity to improvement performance by adding permanent indices ... 

2. Details  ... The $wholeline parameter is all text from the beginning of the line up to the insertion point. The $wholeline parameter is used for context. The $prefix parameter may be NULL, in which case the prefix is deduced from $wholeline. Or ... 

2.5. Statement Journal Files  ... A statement journal is only created for an UPDATE or INSERT statement that might change multiple rows of a database and which might hit a constraint or a RAISE exception within a trigger and thus need to undo partial results ...