Datatypes In SQLite version 2
(datatypes.html)
... So you can declare tables where the datatype of each column
is left unspecified, like this:
CREATE TABLE ex1(a,b,c);
Even though SQLite allows the datatype to be omitted, it is
still a good idea to include it ...
|
C API: Move a BLOB Handle to a New Row
(c3ref/blob_reopen.html)
sqlite3_blob_reopen()
This function is used to move an existing BLOB handle so that it points
to a different row of the same database table. The new row is identified
by the rowid value passed as the second argument. Only the row ...
|
The SQLite Bytecode Engine
(opcode.html)
2.4. B-Tree Cursors
... There can be multiple cursors open on the same index or table.
All cursors operate independently, even cursors pointing to the same
indices or tables.
The only way for the virtual machine to interact with a database
file is through ...
|
UPSERT
(lang_upsert.html)
... To use the
value that would have been inserted had the constraint not failed,
add the special "excluded." table qualifier to the column name.
2.1. Examples
Some examples will help illustrate how UPSERT works:
CREATE TABLE vocabulary(word TEXT ...
|
SQLite Database Speed Comparison
(speed.html)
... DROP TABLE
DROP TABLE t1;DROP TABLE t2;DROP TABLE t3;
PostgreSQL: 0.135
MySQL: 0.015
SQLite 2.7.6: 0.939
SQLite 2.7.6 (nosync):   ...
|
RETURNING
(lang_returning.html)
... The special "*" expression expands into a list
of all non-hidden columns of the table being deleted,
inserted, or updated.
For INSERT and UPDATE statements, references to columns in the table
being modified refer to the value of that column ...
|
C API: Unlock Notification
(c3ref/unlock_notify.html)
sqlite3_unlock_notify()
When running in shared-cache mode, a database operation may fail with
an SQLITE_LOCKED error if the required locks on the shared-cache or
individual tables within the shared-cache cannot be obtained. See
SQLite Shared-Cache Mode for a ...
|
Temporary Files Used By SQLite
(tempfiles.html)
2.6. TEMP Databases
Tables created using the "CREATE TEMP TABLE" syntax are only
visible to the database connection in which the "CREATE TEMP TABLE"
statement is originally evaluated. These TEMP tables, together
with any associated indices, triggers, and views, are collectively
stored in ...
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
2. Recovery Using The ".recover" Command In The CLI
... But if the page really is on the freelist, that can mean that
previously deleted information is reintroduced into the database.
--lost-and-found TABLE
If content is found during recovery that cannot be associated
with a particular table, it ...
|
Row Values
(rowvalue.html)
3.4. Update multiple columns of a table based on a query
The row-value notation is useful for updating two or more columns
of a table from the result of a single query.
An example of this is in the full-text search feature of the
Fossil version control system.
In ...
|
Page generated by FTS5 in about 153.70 ms.