Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The RBU Extension
(rbu.html)
... INSERT statements may not use default values.
UPDATE and DELETE statements must identify the target rows
by rowid or by non-NULL PRIMARY KEY values.
UPDATE statements may not modify PRIMARY KEY or rowid values.
RBU updates cannot be applied ...
|
|
Database File Format
(fileformat.html)
1.3.9. Schema cookie
... A
prepared statement is compiled against a specific version of the
database schema. When the database schema changes, the statement
must be reprepared. When a prepared statement runs, it first checks
the schema cookie to ensure the value is the ...
|
|
Command Line Shell For SQLite
(cli.html)
... SQL statements;
dot-commands; or
CLI comments
SQL statements are free-form, and can be spread across multiple lines,
with whitespace or SQL comments embedded anywhere.
They are terminated by either a ';' character at the end of an input line ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... for public release, make
the SQLite source code and documentation
publicly available as downloadable files
and make a public statement ceding all intellectual
property rights, including but not limited to copyright
and patent rights, in the SQLite source code and ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
... Introduction
The task of the "query planner" is to figure
out the best algorithm or "query plan" to accomplish an SQL statement.
Beginning with SQLite version 3.8.0 (2013-08-26),
the query planner component has been
rewritten so ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
2. Compiling and Enabling FTS3 and FTS4
... If a build of SQLite does not include the FTS modules, then any attempt to prepare an
SQL statement to create an FTS3 or FTS4 table or to drop or access an existing
FTS table in any way will fail ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... The final Halt is also
unnecessary, since it is added to every VDBE program when it is
prepared to run.
UPDATE statements work very much like DELETE statements except
that instead of deleting the record they replace it with a ...
|
|
SQLite FTS5 Extension
(fts5.html)
... Using a MATCH operator in the WHERE clause of a SELECT statement, or
Using an equals ("=") operator in the WHERE clause of a SELECT statement, or
using the table-valued function syntax.
If using the MATCH or = operators, the expression ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The first argument
is a pointer to a customized VFS object that the application has prepared.
The second argument is true to make the new VFS the default VFS so that
it will be used by the legacy sqlite3_open() and ...
|
Page generated by FTS5 in about 110.25 ms.