Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... CREATE TABLE x1(x INTEGER);
INSERT INTO x1 VALUES(1);
INSERT INTO x1 VALUES(2);
INSERT INTO x1 VALUES(NULL);
Given the definition of X1 above, the following expressions have
historically evaluated to FALSE in SQLite, though the correct
answer ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
4.2. Deferred Foreign Key Constraints
Each foreign key constraint in SQLite is classified as either immediate
or deferred. Foreign key constraints are immediate by default.
All the foreign key examples presented
so far have been of immediate foreign key constraints.
If a statement modifies the ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... The key for a row can be accessed in
a SELECT statement or used in a WHERE or ORDER BY clause using any
of the names "ROWID", "OID", or "_ROWID_".
When you do an insert into a table that does ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
... nbsp; ?null-indicator?
Conflict-algorithm must be one of the SQLite conflict algorithms for
the INSERT statement: rollback, abort,
fail,ignore, or replace. See the SQLite Language
section for ON CONFLICT for
more information. The conflict-algorithm must be ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... changes()
The changes() function returns the number of database rows that were changed
or inserted or deleted by the most recently completed INSERT, DELETE,
or UPDATE statement, exclusive of statements in lower-level triggers.
The changes() SQL function is a ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
... SQLite Is Embedded, Not Client-Server
Whenever comparing SQLite to other SQL database engines like
SQL Server, PostgreSQL, MySQL, or Oracle, it is important first of all
to realize that SQLite is not intended as a replacement or competitor to ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
9.1. Shadow Tables
... Multiple b-tree structures are used instead of a single b-tree to reduce
the cost of inserting records into FTS tables. When a new record is
inserted into an FTS table that already contains a lot of data, it ...
|
|
JSON Functions And Operators
(json1.html)
4.14. The json_patch() function
... It can only insert,
replace, or delete the whole Array as a single unit. Hence, json_patch()
is not as useful when dealing with JSON that includes Arrays,
especially Arrays with lots of substructure.
Examples:
json_patch('{"a":1,"b":2}','{"c ...
|
|
Command Line Shell For SQLite
(cli.html)
14.4. SQLite Archive Insert And Update Commands
The --update and --insert commands work like --create command, except that
they do not delete the current archive before commencing. New versions of
files silently replace existing files with the same names, but otherwise
the initial contents of the archive ...
|
|
The SQLite R*Tree Module
(rtree.html)
... And you can UPDATE, DELETE, INSERT or even DROP
the shadow tables, though doing so will corrupt your R*Tree index.
So it is best to simply ignore the shadow tables. Recognize that they
hold your R*Tree index information ...
|
Page generated by FTS5 in about 81.00 ms.