Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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.
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... Content can be accessed and updated using concise SQL queries instead
of lengthy and error-prone procedural routines.
The file format can be extended in future releases simply
by adding new tables and/or column, preserving backwards compatibility.
Applications can ...
|
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
3.8. Further Updates
As new versions of SQLite are released, repeat steps 3.6 and 3.7 to
add changes in the new release to the private branch.
Additional private changes can be
made on the private branch in between releases if desired.
|
|
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 ...
|
|
C API: Number Of Columns In A Result Set
(c3ref/column_count.html)
sqlite3_column_count()
... If this routine returns 0, that means the
prepared statement returns no data (for example an UPDATE).
However, just because this routine returns a positive number does not
mean that one or more rows of data will be returned. A ...
|
|
Isolation In SQLite
(isolation.html)
... X starts a read transaction using BEGIN and SELECT, then
Y makes a changes to the database using UPDATE. Then X tries to make a
change to the database using UPDATE. The attempt by X to escalate its
transaction from ...
|
|
SQLite Archive Files
(sqlar.html)
2. Advantages Of SQLite Archives
... Updates are atomic and durable, even if there are crashes
or power losses in the middle of the update.
Readers see a consistent and unchanging version of the content even
is some other process is simultaneously updating the archive.
An ...
|
|
NUL Characters In Strings
(nulinstr.html)
4. Removing NUL Characters From A Text Field
... So if you have a database file
that contains embedded NULs and you would like to remove them, running
UPDATE statements similar to the following might help:
UPDATE t1 SET b=substr(b,1,instr(b,char(0)))
WHERE instr ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.3. Updating Existing Zip Archive Entries
Existing zip archive entries may be modified using UPDATE statements.
The three leftmost columns of a zipfile virtual table, "name", "mode"
and "mtime", may each be set to any value that may be inserted into the same
column (see above ...
|
|
How To Download Canonical SQLite Source Code
(getthecode.html)
5. Cloning The Complete Development History
... Every time you run "fossil update" it will
automatically reach out to the original repository at
https://www.sqlite.org/src to obtain new check-ins that might have been
made by others since your previous update.
This page last ...
|
Page generated by FTS5 in about 138.34 ms.