Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Constraint Conflict Resolution in SQLite
(conflict.html)
... IGNORE
When a constraint violation occurs, the one row that contains
the constraint violation is not inserted or changed. But the command
continues executing normally. Other rows before and after the row that
contained the constraint violation continue to be ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... IGNORE
When an applicable constraint violation occurs,
the IGNORE resolution algorithm skips the one row that contains
the constraint violation and continues processing subsequent rows
of the SQL statement as if nothing went wrong.
Other rows before and after the ...
|
|
The Session Extension
(sessionintro.html)
2.2. Conflicts
... The target database may contain no row with the specified PRIMARY
KEY values to delete.
The target database may contain a row with the specified PRIMARY
KEY values, but the other fields may contain values that do not
match those ...
|
|
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings
... Thus to count the number
of rows that contain embedded NUL characters:
SELECT count(*) FROM t1 WHERE instr(b,char(0))>0;
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
... Database zDb does not exist,
Table zTable does not exist within database zDb,
Table zTable is a WITHOUT ROWID table,
Column zColumn does not exist,
Row iRow is not present in the table,
The specified column of row iRow contains ...
|
|
C API: Determine if a virtual table query is DISTINCT
(c3ref/vtab_distinct.html)
sqlite3_vtab_distinct()
... Furthermore, when two or more rows
contain the same values for all columns identified by "colUsed", all but
one such row may optionally be omitted from the result.
The virtual table is not required to omit rows that are duplicates ...
|
|
The Schema Table
(schematab.html)
1. Introduction
... CREATE TABLE sqlite_schema(
type text,
name text,
tbl_name text,
rootpage integer,
sql text
);
The sqlite_schema table contains one row for each table, index, view,
and trigger (collectively "objects") in the schema, except there
is no entry for the sqlite_schema table ...
|
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... sqlite_stmt
A table-valued function containing one row for each
prepared statement associated with an open database connection.
swarmvtab
An experimental module providing on-demand read-only access to
multiple tables spread across multiple databases, via a single
virtual table ...
|
|
SQLite FTS5 Extension
(fts5.html)
8. The fts5vocab Virtual Table Module
... An fts5vocab table of type "row" contains one row for each distinct term
in the associated FTS5 table. The table columns are as follows:
ColumnContents
term The term, as stored in the FTS5 index.
doc The number of rows that ...
|
|
SELECT
(lang_select.html)
... In other words, if the left-hand dataset consists of
Nleft rows of
Mleft columns, and the right-hand dataset of
Nright rows of
Mright columns, then the cartesian product is a
dataset of
Nleft×Nright
rows, each containing ...
|
Page generated by FTS5 in about 37.29 ms.