Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
The sqlite3_table_column_metadata(X,D,T,C,....) routine returns
information about column C of table T in database D
on database connection X. The sqlite3_table_column_metadata()
interface returns SQLITE_OK and fills in the non-NULL pointers in
the final five arguments with ...
|
|
C API: Automatically Load Statically Linked Extensions
(c3ref/auto_extension.html)
sqlite3_auto_extension(), struct sqlite3_api_routines
... Calling sqlite3_auto_extension(X) with an entry point X that is already
on the list of automatic extensions is a harmless no-op. No entry point
will be called more than once for each database connection that is opened.
See also ...
|
|
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings
... 1,X'6162630078797a'
In the BLOB output, you can clearly see the NUL character as the 4th
character in the 7-character string.
Another, more automated, way
to tell if a string value X contains embedded NUL characters is to ...
|
|
CREATE TABLE
(lang_createtable.html)
... CREATE TABLE t(x INTEGER PRIMARY KEY ASC, y, z);
CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));
CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x DESC));
But the following declaration does not result in ...
|
|
Window Functions
(windowfunctions.html)
1. Introduction to Window Functions
... CREATE TABLE t0(x INTEGER PRIMARY KEY, y TEXT);
INSERT INTO t0 VALUES (1, 'aaa'), (2, 'ccc'), (3, 'bbb');
-- The following SELECT statement returns:
--
-- x | y | row_number
-----------------------
-- 1 | aaa | 1
-- 2 | ccc | 3
-- 3 | bbb | 2
--
SELECT x, y, row_number ...
|
|
SQLite Download Page
(download.html)
... cd04740c391542745fec69f930714471e17d67dd454dc19fbdb6d1be61ec822e)
Precompiled Binaries for Mac OS X
sqlite-tools-osx-arm64-3510200.zip(4.30 MiB)
Command-line tools for Mac OS-X on ARM,
including (1) the command-line shell, (2) sqldiff,
(3) sqlite3_analyzer, and (4) sqlite3_rsync.
Note: These ...
|
|
SQL Language Expressions
(lang_expr.html)
... The BETWEEN operator
The BETWEEN operator is logically equivalent to a pair of comparisons.
"x BETWEEN y AND z" is
equivalent to
"x>=y AND x<=z" except
that with BETWEEN, the x expression is only evaluated once ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
8.2. Range Queries
... CREATE TABLE ex2(x,y,z);
CREATE INDEX ex2i1 ON ex2(x);
CREATE INDEX ex2i2 ON ex2(y);
SELECT z FROM ex2 WHERE x BETWEEN 1 AND 100 AND y BETWEEN 1 AND 100;
Further suppose that column x contains ...
|
|
SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code
... sqlar_compress(X)
The sqlar_compress(X) function attempts to compress a copy of the
blob X using the Default algorithm and returns the
result as a blob. If the input X is not a compressible blob, then
a copy of X ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
7. Auxiliary Functions
... spellfix1_phonehash(X)
This routine constructs a phonetic hash of the pure ascii input word X
and returns that hash. This routine is used internally by spellfix1 in
order to transform the K1 column of the shadow table into the K2 ...
|
Page generated by FTS5 in about 184.15 ms.