Small. Fast. Reliable.
Choose any three.
Choose any three.
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
2. How It Works
... Rows in
the destination database that could not be paired are output as
INSERTs.
The --primarykey flag changes the pairing algorithm slightly so
that the schema-declared PRIMARY KEY is always used for pairing,
even on tables that have a ...
|
|
Row Values
(rowvalue.html)
2.2. Row Value IN Operators
... CREATE TABLE t2(x,y,z);
INSERT INTO t2(x,y,z) VALUES(1,2,3),(2,3,4),(1,NULL,5);
SELECT
(1,2,3) IN (SELECT * FROM t2), -- 1
(7,8,9) IN (SELECT * FROM t2), -- 0
(1 ...
|
|
JSON Functions And Operators
(json1.html)
4.10. The json_insert(), json_replace, and json_set() functions
... Subsequent arguments occur in pairs with the first
element of each pair being a path and the second element being the value
to insert or replace or set on that path.
Edits occur sequentially from left to right. Changes caused ...
|
|
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 ...
|
|
Isolation In SQLite
(isolation.html)
... In other words, if X begins a write transaction using BEGIN IMMEDIATE
then issues one or more UPDATE, DELETE, and/or INSERT
statements, then those changes are visible to subsequent SELECT statements
that are evaluated in database connection X. SELECT ...
|
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... xBestIndex inserts its
results into the **Outputs** fields.
The aConstraint[] array records WHERE clause constraints of the form:
where OP is =, <, <=, >, or >=. The particular operator is
stored in aConstraint[].op using one of the
SQLITE_INDEX_CONSTRAINT_ values ...
|
|
SQLite Version 3 Overview
(version3.html)
... When data is inserted into a column, that column will make an attempt
to convert the data format into the column's declared type. All SQL
database engines do this. The difference is that SQLite 3.0 will
still store ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
2. Differences From Ordinary Rowid Tables
... But WITHOUT ROWID
tables do follow the standard and will throw an error on any attempt to
insert a NULL into a PRIMARY KEY column.
The sqlite3_last_insert_rowid() function
does not work for WITHOUT ROWID tables.
Inserts into a WITHOUT ROWID ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
6. Binding Parameters and Reusing Prepared Statements
... For example, you might want to evaluate an INSERT statement
multiple times with different values. Or you might want to evaluate
the same query multiple times using a different key in the WHERE clause.
To accommodate
this, SQLite allows SQL ...
|
|
VACUUM
(lang_vacuum.html)
... Frequent inserts, updates, and deletes can cause the database file
to become fragmented - where data for a single table or index is scattered
around the database file. Running VACUUM ensures that each table and
index is largely stored contiguously within ...
|
Page generated by FTS5 in about 150.20 ms.