2.1. Manually Created Imposter Tables One way to create an imposter table is to directly edit the sqlite_schema table to insert a new row that describes the table. For example, suppose the schema is like this: CREATE TABLE t1(a INTEGER PRIMARY KEY,b TEXT ... 

sqlite3_randomness()

SQLite contains a high-quality pseudo-random number generator (PRNG) used to select random ROWIDs when inserting new records into a table that already uses the largest possible ROWID. The PRNG is also used for the built-in random() and ... 

 ... stmt drop-view-stmt expr factored-select-stmt filter-clause foreign-key-clause frame-spec function-arguments indexed-column insert-stmt join-clause join-constraint join-operator literal-value numeric-literal ordering-term over-clause pragma-stmt pragma-value qualified ... 

5. Managing SQLite Archives From Application Code  ... Using the two routines above, it is simple for applications to insert new records into or extract existing records from an SQLite Archive. Insert a new into an SQLite Archive using code like this: INSERT INTO sqlar(name,mode,mtime ... 

 ... CREATE TABLE org( name TEXT PRIMARY KEY, boss TEXT REFERENCES org ) WITHOUT ROWID; INSERT INTO org VALUES('Alice',NULL); INSERT INTO org VALUES('Bob','Alice'); INSERT INTO org VALUES('Cindy','Alice'); INSERT INTO org VALUES('Dave','Bob'); INSERT INTO org ... 

 ... time functions DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW END TRANSACTION EXPLAIN expression INDEXED BY INSERT JSON functions keywords math functions ON CONFLICT clause PRAGMA REINDEX RELEASE SAVEPOINT REPLACE RETURNING clause ROLLBACK TRANSACTION SAVEPOINT SELECT UPDATE ... 

 ... and EXCEPT A rich library of standard SQL functions Aggregate functions including DISTINCT aggregates Window functions UPDATE, DELETE, and INSERT (of course) Common table expressions including recursive common table expressions Row values UPSERT An advanced query planner Full-text search ... 

 ... If an SQL statement is limited to be a million bytes in length, then obviously you will not be able to insert multi-million byte strings by embedding them as literals inside of INSERT statements. But you should not do ... 

sqlite3_reset()

 ... For example, if an INSERT statement with a RETURNING clause is only stepped one time, that one call to sqlite3_step(S) might return SQLITE_ROW but the overall statement might still fail and the sqlite3_reset(S) call might return SQLITE_BUSY if ... 

 ... Used by:   compound-select-stmt   delete-stmt   delete-stmt-limited   factored-select-stmt   insert-stmt   select-stmt   simple-select-stmt   update-stmt   ...