Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Row Values
(rowvalue.html)
2.3. Row Values In UPDATE Statements
Row values can also be used in the SET clause of an UPDATE statement.
The LHS must be a list of column names. The RHS can be any row value.
For example:
UPDATE tab3
SET (a,b,c) = (SELECT x ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... For example, if an UPDATE
statement encountered a constraint violation on the 100th row that
it attempts to update, then the first 99 row changes are preserved
but changes to rows 100 and beyond never occur.
The FAIL behavior only ...
|
|
The Session Extension
(sessionintro.html)
2.3. Changeset Construction
... Or
if a row is updated multiple times within the same session, all updates
are coalesced into a single update within any changeset or patchset blob.
|
|
SQLite Session Module C/C++ Interface
(session.html)
... If the remote
operation was an UPDATE, then the old.* fields of change are updated
to reflect the new.* values in the UPDATE.
Local UPDATE
This may conflict with a remote UPDATE or DELETE. If it conflicts
with a DELETE ...
|
|
SQLite Database Speed Comparison
(speed.html)
... 25000 UPDATEs with an index
BEGIN;
UPDATE t2 SET b=468026 WHERE a=1;
UPDATE t2 SET b=121928 WHERE a=2;
... 24996 lines omitted
UPDATE t2 SET b=35065 WHERE a=24999;
UPDATE t2 SET b=347393 WHERE a ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
4.3.
ON DELETE and ON UPDATE Actions
Foreign key ON DELETE and ON UPDATE clauses are used to configure actions
that take place when deleting rows from the parent table (ON DELETE), or
modifying the parent key values of existing rows (ON UPDATE). A single
foreign key ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
... select-stmt
signed-number
simple-function-invocation
simple-select-stmt
sql-stmt
sql-stmt-list
table-constraint
table-options
table-or-subquery
type-name
update-stmt
update-stmt-limited
upsert-clause
vacuum-stmt
window-defn
window-function-invocation
with-clause
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... CREATE TEMP TRIGGER ex1_it AFTER INSERT ON ex1 BEGIN
INSERT INTO undolog VALUES(NULL,'DELETE FROM ex1 WHERE rowid='||new.rowid);
END;
CREATE TEMP TRIGGER ex1_ut AFTER UPDATE ON ex1 BEGIN
INSERT INTO undolog VALUES(NULL,'UPDATE ex1
SET a ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: update-stmt update-stmt-limited upsert-clause
See also: lang_createtrigger.html lang_insert.html lang_update.html lang_upsert.html
comment-syntax:
See also: lang_comment ...
|
|
SQL Features That SQLite Does Not Implement
(omitted.html)
... You may not execute a DELETE, INSERT, or
UPDATE statement on a view. But you can create a trigger
that fires on an attempt to DELETE, INSERT, or UPDATE a view and do
what you need in the body of ...
|
Page generated by FTS5 in about 134.61 ms.