Small. Fast. Reliable.
Choose any three.
Choose any three.
|
UPSERT
(lang_upsert.html)
... The UPSERT processing happens only for uniqueness constraints.
A "uniqueness constraint"
is an explicit UNIQUE or PRIMARY KEY constraint within
the CREATE TABLE statement, or a unique index.
UPSERT does not intervene for failed NOT NULL, CHECK,
or foreign key ...
|
|
CREATE TABLE
(lang_createtable.html)
... UNIQUE constraints
A UNIQUE constraint is similar to a PRIMARY KEY constraint, except
that a single table may have any number of UNIQUE constraints. For each
UNIQUE constraint on the table, each row must contain a unique combination
of values ...
|
|
Partial Indexes
(partialindex.html)
2.1. Unique Partial Indexes
A partial index definition may include the UNIQUE keyword. If it
does, then SQLite requires every entry in the index to be unique.
This provides a mechanism for enforcing uniqueness across some subset of
the rows in a table.
For ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... No error is returned for uniqueness, NOT NULL, and
UNIQUE constraint errors when the IGNORE conflict resolution
algorithm is used. However, the IGNORE conflict resolution
algorithm works like ABORT for foreign key constraint errors.
REPLACE
When a UNIQUE or PRIMARY ...
|
|
CREATE INDEX
(lang_createindex.html)
... Unique Indexes
If the UNIQUE keyword appears between CREATE and INDEX then duplicate
index entries are not allowed. Any attempt to insert a duplicate entry
will result in an error.
For the purposes of unique indices, all NULL values
are ...
|
|
Rowid Tables
(rowidtable.html)
... Rowid tables are distinguished by the fact that they all have
a unique, non-NULL, signed 64-bit integer rowid that is used as
the access key for the data in the underlying B-tree storage engine.
2.0 Quirks ...
|
|
NULL Handling in SQLite
(nulls.html)
... The only significant difference
is that Informix and MS-SQL both treat NULLs as
indistinct in a UNIQUE column.
The fact that NULLs are distinct for UNIQUE columns but are indistinct for
SELECT DISTINCT and UNION continues to be puzzling ...
|
|
Constraint Conflict Resolution in SQLite
(conflict.html)
Constraint Conflict Resolution in SQLite
In most SQL databases, if you have a UNIQUE, NOT NULL, or
CHECK constraint on
a table and you try to do an UPDATE or INSERT that violates
the constraint, the database will abort the ...
|
|
C API: Number Of SQL Parameters
(c3ref/bind_parameter_count.html)
sqlite3_bind_parameter_count()
... For all forms except ?NNN, this will correspond to the
number of unique parameters. If parameters of the ?NNN form are used,
there may be gaps in the list.
See also: sqlite3_bind(),
sqlite3_bind_parameter_name(), and
sqlite3_bind_parameter_index().
See also lists of
Objects ...
|
|
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table
... This
will affect the numbering of subsequent UNIQUE constraints.
The "sqlite_autoindex_TABLE_N" name is never allocated for an
INTEGER PRIMARY KEY, either in rowid tables or WITHOUT ROWID tables.
tbl_name
The sqlite_schema.tbl_name column holds the name of a table or ...
|
Page generated by FTS5 in about 111.09 ms.