1.1. Tables Without Indices  ... CREATE TABLE FruitsForSale( Fruit TEXT, State TEXT, Price REAL ); With some (arbitrary) data, such a table might be logically stored on disk as shown in figure 1: Figure 1: Logical Layout Of Table "FruitsForSale" In this example, the rowids are ... 

 ... Maximum Number Of Tables In A Schema Each table and index requires at least one page in the database file. An "index" in the previous sentence means an index created explicitly using a CREATE INDEX statement or implicit indices created ... 

sqlite3_stmt_readonly()

 ... Similarly, a CREATE TABLE IF NOT EXISTS statement is a read-only no-op if the table already exists, but sqlite3_stmt_readonly() still returns false for such a statement. If prepared statement X is an EXPLAIN or EXPLAIN QUERY PLAN statement ... 

2. Usage The SQLITE_DBPAGE virtual table read/write table that provides direct access to the underlying disk file on a page-by-page basis. The virtual table appears to have a schema like this: CREATE TABLE sqlite_dbpage( pgno INTEGER PRIMARY KEY, data ... 

 ... For example, to create a new table in a database, you can do this: sqlite3 db1 ./testdb db1 eval {CREATE TABLE t1(a int, b text)} The above code creates a new table named t1 with columns a and b ... 

 ... CREATE TABLE t1(a); CREATE TABLE t2(x); SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1; In version 3.5.9 the query above would return a single column named ... 

 ... Restrictions on UPDATE Statements Within CREATE TRIGGER The following additional syntax restrictions apply to UPDATE statements that occur within the body of a CREATE TRIGGER statement. The table-name specified as part of an UPDATE statement within a trigger body ... 

1. Introduction  ... An SQLite Archive is an ordinary SQLite database file that contains the following table as part of its schema: CREATE TABLE sqlar( name TEXT PRIMARY KEY, -- name of the file mode INT, -- access permissions mtime INT, -- last modification time sz ... 

3.2. Comparison of dates stored as separate fields  ... CREATE TABLE info( year INT, -- 4 digit year month INT, -- 1 through 12 day INT, -- 1 through 31 other_stuff BLOB -- blah blah blah ); When dates are stored this way, row value comparisons provide a convenient way to compare dates: SELECT ... 

sqlite3_blob_open()

This interfaces opens a handle to the BLOB located in row iRow, column zColumn, table zTable in database zDb; in other words, the same BLOB that would be selected by: SELECT zColumn FROM zDb.zTable WHERE rowid = iRow; Parameter zDb ...