sqlite3_blob_reopen()

This function is used to move an existing BLOB handle so that it points to a different row of the same database table. The new row is identified by the rowid value passed as the second argument. Only the row ... 

 ... Syntax The CREATE INDEX command consists of the keywords "CREATE INDEX" followed by the name of the new index, the keyword "ON", the name of a previously created table that is to be indexed, and a parenthesized list of table ... 

 ... So you can declare tables where the datatype of each column is left unspecified, like this: CREATE TABLE ex1(a,b,c); Even though SQLite allows the datatype to be omitted, it is still a good idea to include it ... 

2.4. B-Tree Cursors  ... There can be multiple cursors open on the same index or table. All cursors operate independently, even cursors pointing to the same indices or tables. The only way for the virtual machine to interact with a database file is through ... 

 ... The special "*" expression expands into a list of all non-hidden columns of the table being deleted, inserted, or updated. For INSERT and UPDATE statements, references to columns in the table being modified refer to the value of that column ... 

 ... To use the value that would have been inserted had the constraint not failed, add the special "excluded." table qualifier to the column name. 2.1. Examples Some examples will help illustrate how UPSERT works: CREATE TABLE vocabulary(word TEXT ... 

 ... DROP TABLE DROP TABLE t1;DROP TABLE t2;DROP TABLE t3; PostgreSQL:   0.135 MySQL:   0.015 SQLite 2.7.6:   0.939 SQLite 2.7.6 (nosync):    ... 

sqlite3_changes(), sqlite3_changes64()

 ... For the purposes of this interface, a CREATE TABLE AS SELECT statement does not count as an INSERT, UPDATE or DELETE statement and hence the rows added to the new table by the CREATE TABLE AS SELECT statement are not ... 

sqlite3_unlock_notify()

When running in shared-cache mode, a database operation may fail with an SQLITE_LOCKED error if the required locks on the shared-cache or individual tables within the shared-cache cannot be obtained. See SQLite Shared-Cache Mode for a ... 

2.6. TEMP Databases Tables created using the "CREATE TEMP TABLE" syntax are only visible to the database connection in which the "CREATE TEMP TABLE" statement is originally evaluated. These TEMP tables, together with any associated indices, triggers, and views, are collectively stored in ...