Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Keywords
(lang_keywords.html)
... ABORT
ACTION
ADD
AFTER
ALL
ALTER
ALWAYS
ANALYZE
AND
AS
ASC
ATTACH
AUTOINCREMENT
BEFORE
BEGIN
BETWEEN
BY
CASCADE
CASE
CAST
CHECK
COLLATE
COLUMN
COMMIT
CONFLICT
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DETACH
DISTINCT ...
|
|
CREATE TABLE
(lang_createtable.html)
... A
default value may also be one of the special case-independent keywords
CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP. For the purposes of the
DEFAULT clause, an expression is considered constant if it
contains no sub-queries, column or table references, bound ...
|
|
RETURNING
(lang_returning.html)
... CREATE TABLE t0(
a INTEGER PRIMARY KEY,
b DATE DEFAULT CURRENT_TIMESTAMP,
c INTEGER
);
INSERT INTO t0(c) VALUES(random()) RETURNING *;
In the INSERT statement above, SQLite computes the values for all
three columns. The RETURNING clause causes SQLite to report ...
|
|
ALTER TABLE
(lang_altertable.html)
... The column may not have a default value of CURRENT_TIME, CURRENT_DATE,
CURRENT_TIMESTAMP, or an expression in parentheses.
If a NOT NULL constraint is specified, then the column must have a
default value other than NULL.
If foreign key constraints are ...
|
|
Compile-time Options
(compile.html)
3. Platform Configuration
... HAVE_GMTIME_R
If the HAVE_GMTIME_R option is true and if SQLITE_OMIT_DATETIME_FUNCS is true,
then the CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP keywords will use
the threadsafe "gmtime_r()" interface rather than "gmtime()". In the usual case
where SQLITE_OMIT_DATETIME_FUNCS is not defined or is false ...
|
Page generated by FTS5 in about 5.82 ms.