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 ...
|
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 ...
|
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 ...
|
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 ...
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... The sqlite_sequence system table is neither created, nor
respected if it already exists.
SQLITE_OMIT_AUTOINIT
For backwards compatibility with older versions of SQLite that lack
the sqlite3_initialize() interface, the sqlite3_initialize() interface
is called automatically upon entry to certain key interfaces such ...
|
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 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 ...
|
Books About SQLite
(books.html)
... The book covers basic SQL queries and how they can
be used to create a custom report that includes data from different
tables, and shows how one can use SQL queries to test hypotheses about
the relationships of data in ...
|
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 ...
|
ANALYZE
(lang_analyze.html)
... Older versions of SQLite would make use of the sqlite_stat2 table
or sqlite_stat3 table
when compiled with SQLITE_ENABLE_STAT2 or SQLITE_ENABLE_STAT3,
but all recent versions of
SQLite ignore the sqlite_stat2 and sqlite_stat3 tables.
Future enhancements may create
additional internal tables with ...
|
Page generated by FTS5 in about 142.06 ms.