Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Set the Last Insert Rowid value.
(c3ref/set_last_insert_rowid.html)
sqlite3_set_last_insert_rowid()
The sqlite3_set_last_insert_rowid(D, R) method allows the application to
set the value returned by calling sqlite3_last_insert_rowid(D) to R
without inserting a row into the database.
See also lists of
Objects,
Constants, and
Functions.
|
|
Rowid Tables
(rowidtable.html)
Rowid Tables
1.0 Definition
A "rowid table" is any table in an SQLite schema that
is not a virtual table, and
is not a WITHOUT ROWID table.
Most tables in a typical SQLite database schema are rowid tables.
Rowid ...
|
|
C API: Last Insert Rowid
(c3ref/last_insert_rowid.html)
sqlite3_last_insert_rowid()
Each entry in most SQLite tables (except for WITHOUT ROWID tables)
has a unique 64-bit signed
integer key called the "rowid". The rowid is always available
as an undeclared column named ROWID, OID, or _ROWID_ as long as those ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
1. Introduction
By default, every row in SQLite has a special column, usually called the
"rowid", that uniquely identifies that row within the table. However
if the phrase "WITHOUT ROWID" is added to the end of a CREATE TABLE statement,
then the ...
|
|
SQLite Autoincrement
(autoinc.html)
2. Background
In SQLite, table rows normally have a 64-bit signed integer ROWID
which is unique among all rows in the same table.
(WITHOUT ROWID tables are the exception.)
You can access the ROWID of an SQLite table using one of ...
|
|
CREATE TABLE
(lang_createtable.html)
... 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 table.
This integer is usually
called the "rowid". The rowid ...
|
|
Query Planning
(queryplanner.html)
4. WITHOUT ROWID tables
The basic principals described above apply to both ordinary rowid tables
and WITHOUT ROWID tables.
The only difference is that the rowid column that serves as the key for
tables and that appears as the right-most term in indexes ...
|
|
The UNION Virtual Table
(unionvtab.html)
The UNION virtual table (hereafter: "union-vtab")
is a virtual table that makes multiple independent
rowid tables tables look like a single large table.
The tables that participate in a union-vtab can be in the same
database file, or ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
2. How It Works
... The default behavior is to
treat two rows as pairs if they are in tables with the same name
and they have the same rowid, or in the case of a WITHOUT ROWID
table if they have the same PRIMARY ...
|
|
C API: Data Change Notification Callbacks
(c3ref/update_hook.html)
sqlite3_update_hook()
The sqlite3_update_hook() interface registers a callback function
with the database connection identified by the first argument
to be invoked whenever a row is updated, inserted or deleted in
a rowid table.
Any callback set by a previous call to this ...
|
Page generated by FTS5 in about 126.50 ms.