Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Data Change Notification Callbacks
(c3ref/update_hook.html)
sqlite3_update_hook()
... In the current implementation, the update hook
is not invoked when conflicting rows are deleted because of an
ON CONFLICT REPLACE clause. Nor is the update hook
invoked when rows are deleted using the truncate optimization.
The exceptions defined in ...
|
|
Transaction
(lang_transaction.html)
... But a transaction will also
ROLLBACK if the database is closed or if an error occurs
and the ROLLBACK conflict resolution algorithm is specified.
See the documentation on the ON CONFLICT
clause for additional information about the ROLLBACK
conflict resolution ...
|
|
C API: Allowed return values from sqlite3_txn_state()
(c3ref/c_txn_none.html)
SQLITE_TXN_NONE, SQLITE_TXN_READ, SQLITE_TXN_WRITE
... The sqlite3_txn_state(D,S) interface returns one of these
constants in order to describe the transaction state of schema S
in database connection D.
SQLITE_TXN_NONE
The SQLITE_TXN_NONE state means that no transaction is currently
pending.
SQLITE_TXN_READ
The SQLITE_TXN_READ state means ...
|
|
CREATE TABLE
(lang_createtable.html)
... See
the section titled ON CONFLICT for additional information.
5. ROWIDs and the INTEGER PRIMARY KEY
Except for WITHOUT ROWID tables, all rows within SQLite tables
have a 64-bit signed integer key that uniquely identifies the row within its ...
|
|
Query Language Understood by SQLite
(lang.html)
... INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
END TRANSACTION
EXPLAIN
expression
INDEXED BY
INSERT
JSON functions
keywords
math functions
ON CONFLICT clause
PRAGMA
REINDEX
RELEASE SAVEPOINT
REPLACE
RETURNING clause
ROLLBACK TRANSACTION
SAVEPOINT
SELECT
UPDATE
UPSERT
VACUUM
window functions
WITH clause ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... An ON CONFLICT clause may be specified as part of an UPDATE or INSERT
action within the body of the trigger.
However if an ON CONFLICT clause is specified as part of
the statement causing the trigger to fire, then ...
|
|
Full-Featured SQL
(fullsql.html)
... Table-valued functions
REPLACE INTO
VACUUM
REINDEX
The GLOB operator
Hexadecimal integer literals
The ON CONFLICT clause
The INDEXED BY clause
Virtual tables
Multiple databases on the same database connection using
ATTACH DATABASE
The ability to add application-defined SQL ...
|
|
UPDATE
(lang_update.html)
... The optional "OR action" conflict clause that follows the
UPDATE keyword allows the user to nominate a specific
constraint conflict resolution algorithm to use during this one UPDATE command.
Refer to the section entitled ON CONFLICT for additional information.
2 ...
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
... If the row that a BLOB handle points to is modified by an
UPDATE, DELETE, or by ON CONFLICT side-effects
then the BLOB handle is marked as "expired".
This is true if any column of the row is changed ...
|
|
INSERT
(lang_insert.html)
... The initial "INSERT" keyword can be replaced by
"REPLACE" or "INSERT OR action" to specify an alternative
constraint conflict resolution algorithm to use during
that one INSERT command.
For compatibility with MySQL, the parser allows the use of the
single ...
|
Page generated by FTS5 in about 47.21 ms.