sqlite3_vtab_distinct()

 ... sqlite3_vtab_distinct() return value Rows are returned in aOrderBy order Rows with the same value in all aOrderBy columns are adjacent Duplicates over all colUsed columns may be omitted 0yesyesno 1noyesno 2noyesyes 3yesyesyes For the purposes of comparing virtual table output ... 

2.2. Transient Imposter Tables  ... but instead merely adds an entry in SQLite's internal symbol table. Note that the CREATE TABLE statement must be in the correct format for the index. If the imposter table has the wrong number of columns or is not ... 

 ... Overview The checksum VFS extension is a VFS shim that adds an 8-byte checksum to the end of every page in an SQLite database. The checksum is added as each page is written and verified as each page is ... 

1. Introduction to Foreign Key Constraints  ... If the application requires a stricter relationship between artist and track, where NULL values are not permitted in the trackartist column, simply add the appropriate "NOT NULL" constraint to the schema. There are several other ways to add an equivalent ... 

7.3. File I/O Functions The command-line shell adds two application-defined SQL functions that facilitate reading content from a file into a table column, and writing the content of a column into a file, respectively. The readfile(X) SQL function reads the entire ... 

 ... BLOBs can even be used as PRIMARY KEYs. (11) How do I add, delete or rename columns from an existing table in SQLite? SQLite has limited ALTER TABLE support that you can use to add, rename or drop columns or ... 

 ... not have any PRIMARY KEY columns, it is not an error but no changes are added to the session object. As with other session APIs, tables without PRIMARY KEYs are simply ignored. This function adds a set of changes to ... 

 ... For example, if you insert some UTF-16LE with invalid surrogates into a TEXT column of a table of a database that has PRAGMA encoding=UTF16LE, then later query that column using sqlite3_column_text16(), you will probably get back the same ... 

1.3.10. Schema format number  ... ADD COLUMN functionality. Support for reading and writing format 2 was added in SQLite version 3.1.3 on 2005-02-20. Format 3 adds the ability of extra columns added by ALTER TABLE ... ADD COLUMN to have non-NULL ... 

 ... In version 3.6.0 the column name is just "a". SQLite has never made any promises about the names of columns in the result set of SELECT statement unless the column contains an AS clause. So this change to ...