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 ...
|
|
C API: Compile-Time Authorization Callbacks
(c3ref/set_authorizer.html)
sqlite3_set_authorizer()
... The SQLITE_IGNORE
return can be used to deny an untrusted user access to individual
columns of a table.
When a table is referenced by a SELECT but no column values are
extracted from that table (for example in a query ...
|
|
NULL Handling in SQLite
(nulls.html)
... Thanks.
--
-- If you have to change anything to get this script to run with your database
-- engine, please send your revised script together with your results.
--
-- Create a test table with data
create table t1(a int, b int, c ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... The return value is one
of these:
#define SQLITE_INTEGER 1
#define SQLITE_FLOAT 2
#define SQLITE_TEXT 3
#define SQLITE_BLOB 4
#define SQLITE_NULL 5
The sqlite3_column_decltype() routine returns text which is the
declared type of the column in the CREATE TABLE statement ...
|
|
Constraint Conflict Resolution in SQLite
(conflict.html)
Constraint Conflict Resolution in SQLite
In most SQL databases, if you have a UNIQUE, NOT NULL, or
CHECK constraint on
a table and you try to do an UPDATE or INSERT that violates
the constraint, the database will abort the ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.1. Attribute tables
... It is
convenient to create a single table to handle this storage:
CREATE TABLE attribute(name TEXT PRIMARY KEY, value) WITHOUT ROWID;
Without flexible typing, such a table would need to be more complex,
with separate columns for each possible ...
|
|
SQLite Keywords
(lang_keywords.html)
The SQL standard specifies a large number of keywords which may not
be used as the names of tables, indices, columns, databases, user-defined
functions, collations, virtual table modules, or any other named object.
The list of keywords is so ...
|
|
Datatypes In SQLite
(datatype3.html)
3.3. Column Affinity For Views And Subqueries
... CREATE TABLE t1(a INT, b TEXT, c REAL);
CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11;
The affinity of the v1.x column will be the same as the affinity ...
|
|
The Lemon LALR(1) Parser Generator
(lemon.html)
2. Advantages of Lemon
... For example, when parsing a CREATE TABLE statement,
SQLite invokes the parser recursively to generate an INSERT statement
to make a new entry in the sqlite_schema table.
Lemon has the concept of a non-terminal destructor that can be
used ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2. Using The Geopoly Extension
A geopoly table is created as follows:
CREATE VIRTUAL TABLE newtab USING geopoly(a,b,c);
The statement above creates a new geopoly table named "newtab".
Every geopoly table contains a built-in integer "rowid" column
and a "_shape" column ...
|
Page generated by FTS5 in about 231.02 ms.