Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The INDEXED BY Clause
(lang_indexedby.html)
... The "NOT INDEXED" clause specifies that no index shall be used when
accessing the preceding table, including implied indices create by
UNIQUE and PRIMARY KEY constraints. However, the rowid
can still be used to look up entries even when "NOT ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... The syntax for the ON CONFLICT clause is as shown above for
the CREATE TABLE command. For the INSERT and
UPDATE commands, the keywords "ON CONFLICT" are replaced by "OR" so that
the syntax reads more naturally. For example, instead ...
|
|
Implementation Limits For SQLite
(limits.html)
... Thus the maximum number of pages in a database file is also the upper
bound on the number of tables and indices in a schema. An "index" in
the previous sentences means an index created explicitly using a
CREATE INDEX ...
|
|
C API: Determine If An SQL Statement Writes The Database
(c3ref/stmt_readonly.html)
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 ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
9. Keywords Can Often Be Used As Identifiers
... CREATE TABLE tableZ(INTEGER PRIMARY KEY);
The tableZ table has a single column named "INTEGER". That column
has no datatype specified, but it is the PRIMARY KEY.
The column is not the INTEGER PRIMARY KEY for the table because
it ...
|
|
UPDATE
(lang_update.html)
... 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 ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
6. Checklist For Avoiding Or Fixing Query Planner Problems
... When creating a
new database that you expect to accumulate a lot of data, you can run
the command "ANALYZE sqlite_schema" to create the SQLITE_STAT1 table,
then prepopulate the sqlite_stat1 table (using ordinary INSERT statements)
with content that describes a ...
|
|
ANALYZE
(lang_analyze.html)
... Older versions of SQLite would make use of the sqlite_stat2 table
or sqlite_stat3 table
when compiled with SQLITE_ENABLE_STAT2 or SQLITE_ENABLE_STAT3,
but all recent versions of
SQLite ignore the sqlite_stat2 and sqlite_stat3 tables.
Future enhancements may create
additional internal tables with ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... 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 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.1. The eval method
... 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 ...
|
Page generated by FTS5 in about 272.18 ms.