... INSERT INTO table VALUES(...); The first form (with the "VALUES" keyword) creates one or more new rows in an existing table. If the column-name list after table-name is omitted then the number of values inserted into each row ... 

sqlite3_last_insert_rowid()

Each entry in most SQLite tables (except for WITHOUT ROWID tables) has a unique 64-bit signed integer key called the "rowid". The rowid is always available as an undeclared column named ROWID, OID, or _ROWID_ as long as those ... 

 ... If a schema name is given as the argument, then all tables and indices in that one database are analyzed. If the argument is a table name, then only that table and the indices associated with that table are analyzed ... 

 ... Triggers are automatically dropped when the table that they are associated with (the table-name table) is dropped. However if the trigger actions reference other tables, the trigger is not dropped or modified if those other tables are dropped or ... 

2.6.3. The sqlite_sequence table The sqlite_sequence table is an internal table used to help implement AUTOINCREMENT. The sqlite_sequence table is created automatically whenever any ordinary table with an AUTOINCREMENT integer primary key is created. Once created, the sqlite_sequence table exists in the sqlite_schema table ... 

 ... Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes Indexes can use DESC and COLLATE Partial indexes Indexes On Expressions Clustered indexes Covering indexes CHECK, UNIQUE, NOT NULL ... 

 ... A WITH clause can contain ordinary common table expressions even if it includes the RECURSIVE keyword. The use of RECURSIVE does not force common table expressions to be recursive. 3. Recursive Common Table Expressions A recursive common table expression can ... 

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

 ... The preupdate hook only fires for changes to real database tables; the preupdate hook is not invoked for changes to virtual tables or to system tables like sqlite_sequence or sqlite_stat1. The second parameter to the preupdate callback is a pointer ... 

 ... The SQLITE_SCHEMA table is automatically updated by commands like CREATE TABLE, CREATE INDEX, DROP TABLE, and DROP INDEX. Temporary tables do not appear in the SQLITE_SCHEMA table. Temporary tables and their indices and triggers occur in another special table named ... 

4.1. Background: What Is A Star-Query A star-schema is a common relational database design in which there is a large "fact-table" surrounding by smaller "dimension-tables". The dimension-tables are typically keyed by integer ID values and hold a variety of other attributes that ...