Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7. Special Commands For FTS3 and FTS4
Special INSERT operates can be used to issue commands to FTS3 and FTS4 tables.
Every FTS3 and FTS4 has a hidden, read-only column which is the same name as
the table itself. INSERTs into this hidden column are interpreted ...
|
|
DROP TRIGGER
(lang_droptrigger.html)
... Once removed, the trigger definition is no
longer present in the sqlite_schema (or sqlite_temp_schema) table and is
not fired by any subsequent INSERT, UPDATE or DELETE statements.
Note that triggers are automatically dropped when the associated table is
dropped.
|
|
The RBU Extension
(rbu.html)
2.2.2. RBU Database Contents
For each row to INSERT into the target database as part of the RBU
update, the corresponding data_% table should contain a single record
with the "rbu_control" column set to contain integer value 0. The
other columns should be set ...
|
|
C API: Determine The Virtual Table Conflict Policy
(c3ref/vtab_on_conflict.html)
sqlite3_vtab_on_conflict()
This function may only be called from within a call to the xUpdate method
of a virtual table implementation for an INSERT or UPDATE operation. The
value returned is one of SQLITE_ROLLBACK, SQLITE_IGNORE, SQLITE_FAIL,
SQLITE_ABORT, or SQLITE_REPLACE, according to the ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.3. The 'delete' Command
... The rowid of the row to delete is inserted into the rowid column. The
values inserted into the other columns must match the values currently
stored in the table. For example:
-- Insert a row with rowid=14 into the fts5 ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... Suppose the string to be inserted is stored in a variable
named zString. The code to do the insertion might look like this:
sqlite_exec_printf(db,
"INSERT INTO table1 VALUES('%s')",
0, 0, 0, zString);
If the zString variable holds text ...
|
|
Datatypes In SQLite
(datatype3.html)
3.4. Column Affinity Behavior Example
The following SQL demonstrates how SQLite uses column affinity
to do type conversions when values are inserted into a table.
CREATE TABLE t1(
t TEXT, -- text affinity by rule 2
nu NUMERIC, -- numeric affinity by rule 5
i INTEGER, -- integer ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.27. The preupdate method
This method either registers a callback routine that is invoked just
before each row is modified by an UPDATE, INSERT, or DELETE statement,
or may perform certain operations related to the impending update.
To register or remove a preupdate callback ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
1. Introduction to Foreign Key Constraints
... sqlite> INSERT INTO track VALUES(14, 'Mr. Bojangles', 3);
SQL error: foreign key constraint failed
sqlite> -- This succeeds because a NULL is inserted into trackartist. A
sqlite> -- corresponding row in the artist table is not required in ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... In contrast, if the network link is
inserted into the File I/O channel, transactions may fail
(as for the API Call insertion) but with the additional
effect that the remote database is corrupted.
These network unreliability issues can be ...
|
Page generated by FTS5 in about 178.97 ms.