Small. Fast. Reliable.
Choose any three.
Choose any three.
|
NUL Characters In Strings
(nulinstr.html)
2. Unexpected Behavior
... CREATE TABLE t1(
a INTEGER PRIMARY KEY,
b TEXT
);
INSERT INTO t1(a,b) VALUES(1, 'abc'||char(0)||'xyz');
SELECT a, b, length(b) FROM t1;
The SELECT statement above shows output of:
1,'abc',3
(Through this document ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... If
INDEXED BY is to be used at all, it should be inserted at the very
end of the development process when "locking down" a design.
2. See Also
The query planner checklist describes steps that application
developers should following ...
|
|
Run-Time Loadable Extensions
(loadext.html)
4. Programming Loadable Extensions
... Add an extension loading entry point routine that looks like
something the following:
#ifdef _WIN32
__declspec(dllexport)
#endif
int sqlite3_extension_init( /* <== Change this name, maybe */
sqlite3 *db,
char **pzErrMsg,
const sqlite3_api_routines *pApi
){
int rc = SQLITE_OK;
SQLITE_EXTENSION_INIT2(pApi);
/* insert code to ...
|
|
ANALYZE
(lang_analyze.html)
... Then if a millions of copies of the application are shipped to customers,
the developers are assured that all of those millions of copies are running
the same query plans regardless of what data the individual customers insert
into their ...
|
|
Architecture of SQLite
(arch.html)
... attach.c,
auth.c,
build.c,
delete.c,
expr.c,
insert.c,
pragma.c,
select.c,
trigger.c,
update.c,
vacuum.c,
where.c,
wherecode.c, and
whereexpr.c.
In these files is where most of the serious magic happens ...
|
|
CREATE INDEX
(lang_createindex.html)
... Any attempt to insert a duplicate entry
will result in an error.
For the purposes of unique indices, all NULL values
are considered different from all other NULL values and are thus unique.
This is one of the two possible ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.2. Populating An R*Tree Index
The usual INSERT, UPDATE, and DELETE commands work on an R*Tree
index just like on regular tables. So to insert some data into our sample
R*Tree index, we can do something like this:
INSERT INTO demo_index VALUES
(28215 ...
|
|
SQLite Keywords
(lang_keywords.html)
... FIRST
FOLLOWING
FOR
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP
GROUPS
HAVING
IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LAST
LEFT
LIKE
LIMIT
MATCH
MATERIALIZED
NATURAL
NO
NOT
NOTHING
NOTNULL
NULL
NULLS ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.13. The xUpdate Method
... No insert occurs.
argc > 1 argv[0] = NULL
INSERT: A new row is inserted with column values taken from
argv[2] and following. In a rowid virtual table, if argv[1] is an SQL NULL,
then a new unique ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... This opcode must be followed by either an Insert or InsertIdx opcode
with the OPFLAG_PREFORMAT flag set to complete the insert operation.
RowData
Write into register P2 the complete row content for the row at
which cursor P1 is currently ...
|
Page generated by FTS5 in about 152.91 ms.