Small. Fast. Reliable.
Choose any three.
Choose any three.
|
STRICT Tables
(stricttables.html)
1. Introduction
... For example, if a table column has a type of
"INTEGER", then SQLite tries to convert anything inserted into that column
into an integer. So an attempt to insert the string '123' results
in an integer 123 being inserted. But ...
|
|
The Session Extension
(sessionintro.html)
3.3. Inspecting the Contents of a Changeset
... If the iterator points to a valid entry, the sqlite3changeset_op()
API may be used to determine the type of change (INSERT, UPDATE or
DELETE) that the iterator points to. Additionally, the same API
can be used to obtain the name ...
|
|
SQLite Frequently Asked Questions
(faq.html)
Frequently Asked QuestionsHow do I create an AUTOINCREMENT field?What datatypes does SQLite support?SQLite lets me insert a string into a database column of type integer!Why doesn't SQLite allow me to use '0' and '0.0' as ...
|
|
CREATE TABLE
(lang_createtable.html)
... Each time a row is inserted into the table by an INSERT statement that
does not provide explicit values for all table columns the values stored in
the new row are determined by their default values, as follows:
If the ...
|
|
NULL Handling in SQLite
(nulls.html)
... c int);
insert into t1 values(1,0,0);
insert into t1 values(2,0,1);
insert into t1 values(3,1,0);
insert into t1 values(4,1,1);
insert into t1 values(5,null,0);
insert into t1 ...
|
|
C API: Data Change Notification Callbacks
(c3ref/update_hook.html)
sqlite3_update_hook()
The sqlite3_update_hook() interface registers a callback function
with the database connection identified by the first argument
to be invoked whenever a row is updated, inserted or deleted in
a rowid table.
Any callback set by a previous call to this ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... INSERT UPDATE
The INSERT change remains in the changegroup. The values in the
INSERT change are modified as if the row was inserted by the
existing change and then updated according to the new change.
INSERT DELETE
The existing INSERT ...
|
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1.2. Example Output
... layout
compressed_size int -- Total bytes stored on disk
);
INSERT INTO space_used VALUES('sqlite_schema','sqlite_schema',0,36,36,1,5188,0,0,379,0,1,0,0,27309,0,0,32768);
INSERT INTO space_used VALUES('moz_places','moz_places',0,10955,10894,2 ...
|
|
C API: Total Number Of Rows Modified
(c3ref/total_changes.html)
sqlite3_total_changes(), sqlite3_total_changes64()
These functions return the total number of rows inserted, modified or
deleted by all INSERT, UPDATE or DELETE statements completed
since the database connection was opened, including those executed as
part of trigger programs. The two functions are identical except ...
|
|
SQL Features That SQLite Does Not Implement
(omitted.html)
... You may not execute a DELETE, INSERT, or
UPDATE statement on a view. But you can create a trigger
that fires on an attempt to DELETE, INSERT, or UPDATE a view and do
what you need in the body of ...
|
Page generated by FTS5 in about 153.82 ms.