Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Prepared Statement Scan Status Opcodes
(c3ref/c_scanstat_est.html)
SQLITE_SCANSTAT_NLOOP, SQLITE_SCANSTAT_NVISIT, SQLITE_SCANSTAT_EST, SQLITE_SCANSTAT_NAME, SQLITE_SCANSTAT_EXPLAIN, SQLITE_SCANSTAT_SELECTID ...
... The id value is unique within the
statement. The select-id is the same value as is output in the first
column of an EXPLAIN QUERY PLAN query.
SQLITE_SCANSTAT_PARENTID
The "int" variable pointed to by the V parameter will be ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... The "NOT INDEXED" clause specifies that no index shall be used when
accessing the preceding table, including implied indices create by
UNIQUE and PRIMARY KEY constraints. However, the rowid
can still be used to look up entries even when "NOT ...
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
... value that is not
a TEXT or BLOB value,
Column zColumn is part of an index, PRIMARY KEY or UNIQUE
constraint and the blob is being opened for read/write access,
Foreign key constraints are enabled,
column zColumn is part ...
|
|
STRICT Tables
(stricttables.html)
2. STRICT Tables
... However, even though the PRIMARY KEY has an implicit NOT NULL constraint,
when a NULL value is inserted into an INTEGER PRIMARY KEY column, the
NULL is automatically converted into a unique integer, using the same
rules for INTEGER PRIMARY ...
|
|
Query Planning
(queryplanner.html)
1.1. Tables Without Indices
Most tables in SQLite consist of zero or more rows with a unique integer
key (the rowid or INTEGER PRIMARY KEY) followed by content.
(The exception is WITHOUT ROWID tables.)
The rows
are logically stored in order of increasing rowid ...
|
|
INSERT
(lang_insert.html)
... See the separate UPSERT documentation for the additional trailing
syntax that can cause an INSERT to behave as an UPDATE if the INSERT would
otherwise violate a uniqueness constraint. The upsert clause is not
allowed on an "INSERT ... DEFAULT VALUES".
|
|
SQLite Keywords
(lang_keywords.html)
... RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WINDOW
WITH
WITHOUT
This page last modified on 2022-11-26 14 ...
|
|
Indexes On Expressions
(expridx.html)
2. Restrictions
... Expressions may only be used in CREATE INDEX statements, not within
UNIQUE or PRIMARY KEY constraints within the CREATE TABLE statement.
|
|
Savepoints
(lang_savepoint.html)
... The transaction names need not be unique.
A SAVEPOINT can be started either within or outside of
a BEGIN...COMMIT. When a SAVEPOINT is the outer-most savepoint
and it is not within a BEGIN...COMMIT then the behavior is ...
|
|
pressrelease-20071212.html
(pressrelease-20071212.html)
... This unique structure has enabled Mozilla to
financially support and cultivate competitive, viable community innovation.
For more information, visit www.mozilla.com.
CONTACT INFORMATION:
Mozilla Corporation
Jessica Waight
Tel: +1.415.345.4754
Email: jwaight@outcastpr.com
About Symbian Limited ...
|
Page generated by FTS5 in about 104.59 ms.