INSERT
(lang_insert.html)
... The initial "INSERT" keyword can be replaced by
"REPLACE" or "INSERT OR action" to specify an alternative
constraint conflict resolution algorithm to use during
that one INSERT command.
For compatibility with MySQL, the parser allows the use of the
single ...
|
C API: OS Interface File Virtual Methods Object
(c3ref/io_methods.html)
struct sqlite3_io_methods
... The flags argument to xSync may be one of SQLITE_SYNC_NORMAL or
SQLITE_SYNC_FULL. The first choice is the normal fsync().
The second choice is a Mac OS X style fullsync. The SQLITE_SYNC_DATAONLY
flag may be ORed in to indicate that only ...
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The SQLITE_LOCKED result code differs from SQLITE_BUSY in that
SQLITE_LOCKED indicates a conflict on the same database connection
(or on a connection with a shared cache) whereas SQLITE_BUSY indicates
a conflict with a different database connection, probably in a different ...
|
Distinctive Features Of SQLite
(different.html)
... SQLite also provides statements such as
REPLACE and the
ON CONFLICT clause that allow for
added control over the resolution of constraint conflicts.
SQLite supports ATTACH and
DETACH commands that allow multiple
independent databases to be used together in the ...
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... dbcmd copy conflict-algorithm
table-name file-name
?column-separator?
?null-indicator?
Conflict-algorithm must be one of the SQLite conflict algorithms for
the ...
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: column-def
References: conflict-clause expr foreign-key-clause literal-value signed-number
See also: gencol.html lang_altertable.html lang_createtable ...
|
The RBU Extension
(rbu.html)
... The target database may not contain indexes on expressions.
Indexes on expressions are supported beginning with SQLite 3.30.0
(2019-10-04).
No other writes may occur on the target database while the
RBU update is being applied. A ...
|
STRICT Tables
(stricttables.html)
2. STRICT Tables
... ON CONFLICT clauses work the same.
Indexes work the same.
AUTOINCREMENT works the same.
An INTEGER PRIMARY KEY column is an alias for the rowid, but an
INT PRIMARY KEY column is not.
The on-disk format for the table ...
|
Run-Time Loadable Extensions
(loadext.html)
4. Programming Loadable Extensions
... Put the macro "SQLITE_EXTENSION_INIT1" on a line by itself
right after the "#include <sqlite3ext.h>" line.
Add an extension loading entry point routine that looks like
something the following:
#ifdef _WIN32
__declspec(dllexport)
#endif
int sqlite3_extension_init( /* <== Change ...
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... constitute
one and the same agreement.
8.7 Governing Law.
This Agreement will be interpreted and construed in
accordance with the laws of the State of North Carolina
and the United States of America, without regard to
conflict of law ...
|
Page generated by FTS5 in about 28.09 ms.