Small. Fast. Reliable.
Choose any three.
Choose any three.
|
CREATE TRIGGER
(lang_createtrigger.html)
... For non-TEMP triggers,
the table to be modified or queried must exist in the
same database as the table or view to which the trigger is attached.
TEMP triggers are not subject to the same-database rule. A TEMP ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview
The "swarmvtab" virtual table allows the user to query a large number
of tables (hereafter "component" tables) with similar schemas but distinct
ranges of rowid values as if they were a single database table. The tables may
be (and usually ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... For
example, we have shown how sorting is accomplished on a simple query
and we have shown how to implement a compound query. But we did
not give an example of sorting in a compound query. This is because
sorting ...
|
|
The SQLITE_MEMSTAT Virtual Table
(memstat.html)
2. Usage
The SQLITE_MEMSTAT virtual table is a read-only table that can be
queried to determine performance characteristics (primarily the
amount of memory being used) of the current instance of SQLite.
The SQLITE_MEMSTATE table is essentially a wrapper around the
C ...
|
|
C API: Status Parameters for prepared statements
(c3ref/c_stmtstatus_counter.html)
SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ...
... SQLITE_STMTSTATUS_REPREPARE
This is the number of times that the prepare statement has been
automatically regenerated due to schema changes or changes to
bound parameters that might affect the query plan.
SQLITE_STMTSTATUS_RUN
This is the number of times that the prepared ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... SELECT manifest, versionId, max(checkinTime) FROM version;
Using a single query such as the above, the application obtains a list
of the slideIds for all slides in the presentation. The application then
queries for the content of the first slide ...
|
|
C API: Mutex Methods Object
(c3ref/mutex_methods.html)
struct sqlite3_mutex_methods
... Additionally, an instance of this structure can be used as an
output variable when querying the system for the current mutex
implementation, using the SQLITE_CONFIG_GETMUTEX option.
The xMutexInit method defined by this structure is invoked as
part of system initialization ...
|
|
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 ...
|
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... But there is great risk in merely
defining such a function, even if the application itself never invokes
it!
Suppose the application normally does a query against table TAB1
when it starts up. If an attacker can gain access to ...
|
|
Books About SQLite
(books.html)
... The book covers basic SQL queries and how they can
be used to create a custom report that includes data from different
tables, and shows how one can use SQL queries to test hypotheses about
the relationships of data in ...
|
Page generated by FTS5 in about 310.78 ms.