Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLITE_STMT Virtual Table
(stmt.html)
2.1. Columns
... The number of columns in the result set of a query.
For DML statements, this column has a value of 0.
ro:
The "read only" column. This column is true (non-zero) if the
SQL statement is a query and ...
|
|
C API: Obtain Aggregate Function Context
(c3ref/aggregate_context.html)
sqlite3_aggregate_context()
... When no rows match
an aggregate query, the xStep() callback of the aggregate function
implementation is never called and xFinal() is called exactly once.
In those cases, sqlite3_aggregate_context() might be called for the
first time from within xFinal().
The sqlite3_aggregate_context ...
|
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... carray
A table-valued function that allows a C-language array of integers,
doubles, or strings to be used as table in a query.
closure
Compute the transitive closure of a set.
completion
Suggests completions for partially-entered words during ...
|
|
C API: Determine If An SQL Statement Writes The Database
(c3ref/stmt_readonly.html)
sqlite3_stmt_readonly()
... If prepared statement X is an EXPLAIN or EXPLAIN QUERY PLAN
statement, then sqlite3_stmt_readonly(X) returns the same value as
if the EXPLAIN or EXPLAIN QUERY PLAN prefix were omitted.
See also lists of
Objects,
Constants, and
Functions.
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
... The default value for top is 20, but that
can be changed for each query by including a term of
the form "top=N" in the WHERE clause of the query.
scope
(HIDDEN) For any query, this value is the ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA threads
PRAGMA threads;
PRAGMA threads = N;
Query or change the value of the
sqlite3_limit(db,SQLITE_LIMIT_WORKER_THREADS,...) limit for
the current database connection. This limit sets an upper bound
on the number of auxiliary threads that a prepared statement is
allowed to ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
5. Enabling Shared-Cache Mode
... When URI filenames are used, the "cache" query parameter can be used
to specify whether or not the database will use shared cache. Use
"cache=shared" to enable shared cache and "cache=private" to disable
shared cache. The ability to ...
|
|
Command Line Shell For SQLite
(cli.html)
5. Querying the database schema
... The ".fullschema" command normally
provides all of the information needed to exactly recreate a query
plan for a specific query. When reporting suspected problems with
the SQLite query planner to the SQLite development team, developers
are requested to provide the ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
1. Overview
... For any
particular query, the schema can be changed by specifying the
alternative schema as a function argument to the virtual table
name in the FROM clause of the query. (See further discussion of
table-valued functions in the FROM ...
|
|
SQL Comment Syntax
(lang_comment.html)
Comments are not SQL commands, but can occur within the text of
SQL queries passed to sqlite3_prepare_v2() and related interfaces.
Comments are treated as whitespace by the parser.
Comments can begin anywhere whitespace
can be found, including inside expressions that ...
|
Page generated by FTS5 in about 196.78 ms.