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 ...
|
|
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 ...
|
|
Row Values
(rowvalue.html)
1. Definitions
... The "size" of a row value is the number of scalar values the row value contains.
The size of a row value is always at least 2.
A row value with a single column is just a scalar value.
A ...
|
|
Query Planning
(queryplanner.html)
1.3. Lookup By Index
... Then the database engines does a second binary search
on the original FruitsForSale table to find the
original row that contains fruit='Peach'.
From the row in the FruitsForSale table,
SQLite can then extract the value of the price column ...
|
|
CREATE TABLE
(lang_createtable.html)
... For each
UNIQUE constraint on the table, each row must contain a unique combination
of values in the columns identified by the UNIQUE constraint.
For the purposes of UNIQUE constraints, NULL values
are considered distinct from all other values, including ...
|
Page generated by FTS5 in about 20.00 ms.