Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Pointer Passing Interfaces
(bindptr.html)
4. Restrictions On The Use of Pointer Values
... The latter fact is why there is no
sqlite3_column_pointer() interface, since it is impossible to
predict whether or not the query planner will insert a sort operation
prior to returning a value from a query, so it would be impossible ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2. Using The Geopoly Extension
... Store new polygons in the table using ordinary INSERT statements:
INSERT INTO newtab(_shape) VALUES('[[0,0],[1,0],[0.5,1],[0,0]]');
UPDATE and DELETE statements work similarly.
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA count_changes
... When count-changes is set, each of these commands
returns a single row of data consisting of one integer value - the
number of rows inserted, modified or deleted by the command. The
returned change count does not include any insertions ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... An INSERT statement with multiple values in the VALUES clause is
implemented internally as a compound SELECT. Hence, this option also
disables the ability to insert more than a single row using an
INSERT INTO ... VALUES ... statement.
SQLITE_OMIT_CTE
This option ...
|
|
SQLite Older News
(oldnews.html)
... But for the pasts seven months
(version 3.8.7 through version 3.8.10.1)
if you do an INSERT into a carefully
crafted schema in which there are two nested triggers that convert
an index key value from ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1. The EXPLAIN QUERY PLAN Command
... UPDATE, DELETE, INSERT INTO ... SELECT).
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.1.7. Memory allocator overlays
An application can insert layers or "overlays" in between the
SQLite core and the underlying memory allocator.
For example, the out-of-memory test logic
for SQLite uses an overlay that can simulate memory allocation
failures.
An overlay can be ...
|
|
Quality Management
(qmplan.html)
8. Problem Reports
... All content
entered is synced to all repositories, regardless of which repository is
used for insertion.
This page last modified on 2022-04-18 02:55:50 UTC
|
|
Database File Format
(fileformat.html)
2.6.3. The sqlite_sequence table
... The name of the table (as it appears in
sqlite_schema.name) is in the sqlite_sequence.name field and the largest
INTEGER PRIMARY KEY ever inserted into that table is
in the sqlite_sequence.seq field.
New automatically generated integer primary keys ...
|
|
ALTER TABLE
(lang_altertable.html)
... not collide
with any existing table name, of course.
Transfer content from X into new_X using a statement
like: INSERT INTO new_X SELECT ... FROM X.
Drop the old table X: DROP TABLE X.
Change the name of new_X to X ...
|
Page generated by FTS5 in about 161.80 ms.