Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-In Mathematical SQL Functions
(lang_mathfunc.html)
... acos(X)
acosh(X)
asin(X)
asinh(X)
atan(X)
atan2(Y,X)
atanh(X)
ceil(X)
ceiling(X)
cos(X)
cosh(X)
degrees(X)
exp(X)
floor(X)
ln(X)
log(B,X)
log(X)
log10(X)
log2(X ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... List Of Core Functions
abs(X)
changes()
char(X1,X2,...,XN)
coalesce(X,Y,...)
concat(X,...)
concat_ws(SEP,X,...)
format(FORMAT,...)
glob(X,Y)
hex(X)
if(B1,V1,...)
ifnull(X,Y)
iif(B1,V1,...)
instr(X,Y)
last_insert_rowid()
length ...
|
|
The Use Of assert() In SQLite
(assert.html)
1. Assert() And Similar Macros In SQLite
The assert(X) macro is
part of standard C, in the
<assert.h> header file.
SQLite adds three other assert()-like macros named NEVER(X), ALWAYS(X),
and testcase(X).
assert(X) →
The assert(X) statement indicates ...
|
|
C API: Report the internal text encoding state of an sqlite3_value object
(c3ref/value_encoding.html)
sqlite3_value_encoding()
The sqlite3_value_encoding(X) interface returns one of SQLITE_UTF8,
SQLITE_UTF16BE, or SQLITE_UTF16LE according to the current text encoding
of the value X, assuming that X has type TEXT. If sqlite3_value_type(X)
returns something other than SQLITE_TEXT, then the return value from ...
|
|
C API: Status Of A Dynamic String
(c3ref/str_errcode.html)
sqlite3_str_errcode(), sqlite3_str_length(), sqlite3_str_value()
... The sqlite3_str_length(X) method returns the current length, in bytes,
of the dynamic string under construction in sqlite3_str object X.
The length returned by sqlite3_str_length(X) does not include the
zero-termination byte.
The sqlite3_str_value(X) method returns a pointer ...
|
|
C API: Add Content To A Dynamic String
(c3ref/str_append.html)
sqlite3_str_appendf(), sqlite3_str_vappendf(), sqlite3_str_append(), sqlite3_str_appendall(), sqlite3_str_appendchar(), sqlite3_str_reset()
... The sqlite3_str_appendf(X,F,...) and
sqlite3_str_vappendf(X,F,V) interfaces uses the built-in printf
functionality of SQLite to append formatted text onto the end of
sqlite3_str object X.
The sqlite3_str_append(X,S,N) method appends exactly N bytes from ...
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... List of built-in aggregate functions
avg(X)
count(*)
count(X)
group_concat(X)
group_concat(X,Y)
max(X)
min(X)
string_agg(X,Y)
sum(X)
total(X)
3. Descriptions of built-in aggregate functions
avg(X)
The avg() function
returns ...
|
|
C API: Memory Allocation Subsystem
(c3ref/free.html)
sqlite3_malloc(), sqlite3_malloc64(), sqlite3_realloc(), sqlite3_realloc64(), sqlite3_free(), sqlite3_msize()
... The value returned by sqlite3_msize(X) might be larger than the number
of bytes requested when X was allocated. If X is a NULL pointer then
sqlite3_msize(X) returns zero. If X points to something that is not
the beginning ...
|
|
C API: SQL Trace Hook
(c3ref/trace_v2.html)
sqlite3_trace_v2()
The sqlite3_trace_v2(D,M,X,P) interface registers a trace callback
function X against database connection D, using property mask M
and context pointer P. If the X callback is
NULL or if the M mask is zero, then tracing ...
|
|
C API: Cancel Automatic Extension Loading
(c3ref/cancel_auto_extension.html)
sqlite3_cancel_auto_extension()
The sqlite3_cancel_auto_extension(X) interface unregisters the
initialization routine X that was registered using a prior call to
sqlite3_auto_extension(X). The sqlite3_cancel_auto_extension(X)
routine returns 1 if initialization routine X was successfully
unregistered and it returns 0 if X was not ...
|
Page generated by FTS5 in about 121.49 ms.