Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... The first argument of each
pair is a Boolean and the second argument is a value to return if the Boolean is true.
The iif() function returns the value associated with the first true Boolean.
If the number of arguments ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA trusted_schema
PRAGMA trusted_schema;
PRAGMA trusted_schema = boolean;
The trusted_schema setting is a per-connection boolean that
determines whether or not SQL functions and virtual tables that
have not been security audited are allowed to be run by views,
triggers, or in expressions ...
|
|
The SQLITE_STMT Virtual Table
(stmt.html)
2.1. Columns
... CREATE TABLE sqlite_stmt(
sql TEXT, -- Original SQL text
ncol INT, -- Number of output columns
ro BOOLEAN, -- True for "read only" statements
busy BOOLEAN, -- True if the statement is current running
nscan INT, -- Number of full-scan steps
nsort INT, -- Number ...
|
|
SQL Language Expressions
(lang_expr.html)
... Boolean Expressions
The SQL language features several contexts where an expression is
evaluated and the result converted to a boolean (true or false) value. These
contexts are:
the WHERE clause of a SELECT, UPDATE or DELETE statement,
the ON or ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
3.1. No Separate BOOLEAN Datatype
Unlike most other SQL implementations,
SQLite does not have a separate BOOLEAN data type.
Instead, TRUE and FALSE are (normally) represented as integers 1 and 0,
respectively.
This does not seem to cause many problems, as we seldom get complaints ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3. The Tcl interface to the SQLite library
... The default behavior is "true".
-nomutex BOOLEAN
If true, then all mutexes for the database connection are disabled.
This provides a small performance boost in single-threaded applications.
-readonly BOOLEAN
If true, then open the database file read-only. If ...
|
|
C API: Obtain Values For URI Parameters
(c3ref/uri_boolean.html)
sqlite3_uri_parameter(), sqlite3_uri_boolean(), sqlite3_uri_int64(), sqlite3_uri_key()
... The sqlite3_uri_boolean(F,P,B) routine assumes that P is a boolean
parameter and returns true (1) or false (0) according to the value
of P. The sqlite3_uri_boolean(F,P,B) routine returns true (1) if the
value of query ...
|
|
Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... immutable=1
The immutable query parameter is a boolean that signals to
SQLite that the underlying database file is held on read-only media
and cannot be modified, even by another process with elevated
privileges. SQLite always opens immutable database ...
|
|
The CSV Virtual Table
(csv.html)
2. Arguments
... header=BOOLEAN
or just
header
If the header argument is true then the first row of the CSV file
to be treated as a header rather than as data. The second line of the CSV
file becomes the first row ...
|
|
The Use Of assert() In SQLite
(assert.html)
1. Assert() And Similar Macros In SQLite
... ALWAYS(X) behaves like
a function that returns the boolean value X, and is intended to be used
within the conditional of an "if" statement.
NEVER(X) →
The NEVER(X) function indicates that condition X is never true. This ...
|
Page generated by FTS5 in about 84.30 ms.