A platform combines multiple tutorials, projects, documentations, questions and answers for developers
  • Home (current)
  • Documentations
  • About
  • Login
  1. Home
  2. Documentations
  3. SQLite
  4. SQLite Syntax: upsert-clause

upsert-clause

ON CONFLICT ( indexed-column ) WHERE expr DO , conflict target UPDATE SET column-name-list = expr WHERE expr NOTHING , column-name

Used by: insert-stmt
References: column-name-list expr indexed-column
See also: lang_createtrigger.html lang_insert.html lang_upsert.html

SQLite is in the Public Domain.
https://sqlite.org/syntax/upsert-clause.html

Full-Text Search
"automerge" command
"merge" command
"optimize" command
"rebuild" command
Write-Ahead Logging
"shm" file
Advantages of WAL-mode
Auxiliary function mapping
Avoiding large WAL files
Comparison with fts4
Compile fts
Compressed FTS4 content
Contentless fts4 tables
Custom auxiliary functions
Custom tokenizers
Enhanced query syntax
Extending FTS5
External content fts4 tables
FTS MATCH
FTS auxiliary functions
FTS hidden column
FTS shadow tables
FTS4
FTS4 "automerge" command
FTS4 "integrity-check" command
FTS4 "merge" command
FTS4 "optimize" command
FTS4 "rebuild" command
FTS4 commands
FTS4 content option
FTS4 languageid option
FTS4 matchinfo option
FTS4 notindexed option
FTS4 options
FTS4 order option
FTS4 prefix option
FTS5 CREATE TABLE Options
FTS5 NEAR queries
FTS5 Phrases
FTS5 Strings
FTS5 automerge option
FTS5 auxiliary functions
FTS5 bm25
FTS5 boolean operators
FTS5 building
FTS5 column filters
FTS5 columnsize option
FTS5 content option
FTS5 contentless tables
FTS5 custom auxiliary functions
FTS5 delete command
FTS5 delete-all command
FTS5 detail option
FTS5 external content tables
FTS5 highlight
FTS5 initial token
FTS5 initial token queries
FTS5 merge command
FTS5 optimize command
FTS5 pgsz option
FTS5 prefix indexes
FTS5 prefix queries
FTS5 query syntax
FTS5 rank configuration option
FTS5 rebuild command
FTS5 snippet
FTS5 tokenizers
FTS5 usermerge option
Large WAL files
Matchinfo b flag
Matchinfo x flag
Matchinfo y flag
NEAR queries
Phrase queries
Prefix queries
Prefix query
SQLite FTS3 and FTS4 Extensions
SQLite FTS5 Extension
Search application tips
Segment btree
Simple fts queries
Trigram indexes
Trigram tokenizer
WAL backwards compatibility
WAL concurrency
WAL file
WAL without shared memory
WAL-index File Format
WAL-index format
WAL-mode File Format
WAL-mode crash recovery
WAL-mode locks
WAL-mode read blocking
Write-Ahead Logging
bugs
checkpoint
checkpointed
checkpointing
commands
fts3_tokenizer
fts3tokenize
fts3tokenize virtual table
fts4 compress option
fts4aux
fts4aux languageid column
fts5 shadow tables
fts5 technical differences
fts5vocab
languageid
matchinfo
mxFrame
nBackfill
read-only WAL databases
recovery
shadowtabs
snippet
tokenizer
unicode61
unindexed
wal-index
Miscellaneous
8+3 Filenames
35% Faster Than The Filesystem
%q
%w
%z
.imposter dot-command
Adding to Zip
Aggregate window functions
An Asynchronous I/O Module For SQLite
Application-Defined SQL Functions
Appropriate Uses For SQLite
Architecture of SQLite
Atomic Commit In SQLite
Automatic Undo/Redo With SQLite
Benefits of SQLite As A File Format
Benefits of using WITHOUT ROWID
Building a DLL
Building the amalgamation
Builtin window functions
Change in Default Page Size in SQLite Version 3.12.0
Clustered Indexes and the WITHOUT ROWID Optimization
Code Of Conduct
Code Of Ethics
Compile loadable extensions
Compile-time Options
Compiling Loadable Extensions
Compiling the CLI
Compiling the TCL interface
Configurable edit distances
Constraint Conflict Resolution in SQLite
Custom Builds Of SQLite
DBSTAT aggregated mode
Database as container object
Database as object
Database corruption caused by inconsistent use of 8+3 filenames
Decimal extension
Defense Against Dark Arts
Deterministic SQL Functions
Distinctive Features Of SQLite
EXPLAIN QUERY PLAN
Exclude clause
Extended error code
Extended result code
Features Of SQLite
File Format Changes in SQLite
Floating Point Numbers
Frame boundary
Frame specification
Frame type
Full-Featured SQL
GROUPS frames
Generated Columns
High Reliability
Hints for Debugging SQLite
How SQLite Is Tested
How SQLite Works
How To Compile SQLite
How To Download Canonical SQLite Source Code
Imposter Tables
In-Memory Databases
Indexes On Expressions
Internal Versus External BLOBs
Isolation In SQLite
List of current bytecodes
LoC Recommended Storage Format
Long Term Support
Maintaining Private Branches Of SQLite
Managing SQLite Archives from the command-line
Many Small Queries Are Efficient In SQLite
Master journal
Maxopen parameter
Measuring and Reducing CPU Usage in SQLite
Memory-Mapped I/O
Missing callback
Mutation test script
NUL Characters In Strings
NULL Handling in SQLite
Opcode definitions
Openclose callback
Partial Indexes
Persistent loadable extensions
Pointer Passing Interfaces
Pointer leak
Pointer types
Powersafe Overwrite
Primary versus extended result codes
Programming Loadable Extensions
Quality Management
Quirks, Caveats, and Gotchas In SQLite
RANGE frames
RANGE n FOLLOWING
RANGE n PRECEDING
Recent CVEs
Release History Of SQLite
Result and Error Codes
Row Values
Rowid Tables
Run-Time Loadable Extensions
SQL Features That SQLite Does Not Implement
SQLite Archive Files
SQLite Archive smaller than ZIP
SQLite As An Application File Format
SQLite Autoincrement
SQLite Backup API
SQLite Changes From Version 3.4.2 To 3.5.0
SQLite Changes From Version 3.5.9 To 3.6.0
SQLite Database Speed Comparison
SQLite File IO Specification
SQLite Frequently Asked Questions
SQLite In 5 Minutes Or Less
SQLite Is Serverless
SQLite Is Transactional
SQLite Library Footprint
SQLite Over a Network, Caveats and Considerations
SQLite Shared-Cache Mode
SQLite Unlock-Notify API
SQLite Version 3 Overview
SQLite is a Self Contained System
SQLite's Built-in printf()
SQLite: Single File Database
Split amalgamation
Statement journal
Swarmvtab Virtual Table
Swarmvtab context
TH3
Temporary Files Used By SQLite
Temporary databases
Temporary directory search algorithm
Temporary tables
The Bytecode() And Tables_Used() Table-Valued Functions
The COMPLETION() Table-Valued Function
The CSV Virtual Table
The Checksum VFS Shim
The DBSTAT Virtual Table
The Error And Warning Log
The Lemon LALR(1) Parser Generator
The SQLITE_DBPAGE Virtual Table
The SQLITE_MEMSTAT Virtual Table
The SQLITE_STMT Virtual Table
The SQLite Amalgamation
The SQLite Bytecode Engine
The SQLite OS Interface or "VFS"
The SQLite Zipfile Module
The Schema Table
The Spellfix1 Virtual Table
The UINT Collating Sequence
The UNION Virtual Table
The Use Of assert() In SQLite
The Virtual Database Engine of SQLite
The dbhash.exe Utility Program
The generate_series Table-Valued Function
The sqlite3_analyzer.exe Utility Program
Things That Can Go Wrong
Torn page
Uniform Resource Identifiers
Using SQLite In Multi-Threaded Applications
VFS shim
Version Numbers in SQLite
Vulnerabilities
What If OpenDocument Used SQLite?
When to use WITHOUT ROWID
Why Is SQLite Coded In C
Why SQLite Does Not Use Git
Window Functions
Window chaining
Zero-Configuration
advanced
application-defined function attacks
application-defined window functions
built-in window functions
built-ins
compilation
date/time special case
double-quoted string literal
editdist3
frames
ieee754 extension
ieee754() function
ieee754_exponent() function
ieee754_from_blob() function
ieee754_mantissa() function
ieee754_to_blob() function
in-memory shared cache database
in-memory shared-cache
microoptimizations
partition
shims
sqldiff.exe: Database Difference Utility
subprograms
super-journal
swarmvtab
user-defined window functions
Language
'utc' modifier
ALTER TABLE
ALTER TABLE ADD COLUMN
ALTER TABLE DROP COLUMN
ALTER TABLE RENAME
ALTER TABLE RENAME COLUMN
ALTER TABLE RENAME documentation
ANALYZE
ATTACH DATABASE
Add column
Approximate ANALYZE
Automatically running ANALYZE
BEGIN EXCLUSIVE
BEGIN IMMEDIATE
BETWEEN
Bare aggregate terms
Binary operators
Boolean expression
Bound parameter
Built-In Mathematical SQL Functions
Built-In Scalar SQL Functions
Built-in Aggregate Functions
CASE expression
CAST
CAST expression
CAST operator
CHECK
CHECK constraint
COLLATE
COLLATE clause
COLLATE constraint
COLLATE operator
CREATE INDEX
CREATE TABLE
CREATE TABLE AS
CREATE TRIGGER
CREATE VIEW
CREATE VIRTUAL TABLE
Column definition
Compound query
Compound select
Compute the Mandelbrot set
Correlated subqueries
DEFAULT clauses
DELETE
DESC
DETACH
DISTINCT
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
Database Object Name Resolution
Date And Time Functions
Default column value
Default value
Descending index
Descending indexes
Descending indices
Drop column
ESCAPE
EXISTS operator
EXPLAIN
FILTER clause on aggregate functions
FROM clause
GROUP BY
Generalized ALTER TABLE procedure
Hexadecimal integer literals
Hexadecimal integers
How vacuum works
IN operator
INSERT
INSTEAD OF
INSTEAD OF trigger
INTEGER PRIMARY KEY
IS NOT operator
IS operator
LIMIT
Literal value
Localtime modifier
MATCH
MATERIALIZED
Materialization hints
NOT EXISTS operator
NOT IN operator
NOT MATERIALIZED
NOT NULL
NOT NULL constraint
NULLS FIRST
NULLS LAST
OFFSET
ORDER BY
Ordinary common table expressions
PRIMARY KEY
PRIMARY KEY constraint
Queries against graphs
Query Language Understood by SQLite
RAISE function
REGEXP
REINDEX
REPLACE
RETURNING
ROWID
Recommended ANALYZE usage pattern
Recursive common table expression
Recursive query
Rename column
Rename table
SELECT
SQL Comment Syntax
SQL Language Expressions
SQLite Keywords
Savepoints
Simple SELECT
Solve Sudoku puzzles
Subqueries
TEMP triggers on non-TEMP tables
The INDEXED BY Clause
The ON CONFLICT Clause
The WITH Clause
Transaction
Treats the CROSS JOIN operator specially
Truncate optimization
UNIQUE
UPDATE
UPDATE FROM
UPSERT
UPSERT parsing ambiguity
Undefined BEFORE trigger behavior
Unique constraint
Unique index
VACUUM
VACUUM INTO
VALUES
VALUES clause
WHERE clause
Why ALTER TABLE is so difficult
abs()
acos()
acosh()
asin()
asinh()
atan()
atan2()
atanh()
avg() aggregate function
ceil
ceiling
changes()
char()
coalesce()
cos()
cosh()
count() aggregate function
degrees()
exp()
floor()
glob()
group_concat() aggregate function
hex()
ifnull()
iif()
instr()
last_insert_rowid()
length()
like()
likelihood()
likely()
ln()
load_extension()
log
log10
log2()
lower()
ltrim()
max()
max() aggregate function
min()
min() aggregate function
mod()
nullif()
parameter
pi()
pow()
printf()
quote()
radians()
random()
randomblob()
replace()
result-set expressions
round()
rtrim()
sign()
sin()
sinh()
soundex()
sqlite_compileoption_get()
sqlite_compileoption_used()
sqlite_offset()
sqlite_source_id()
sqlite_version()
sqrt()
substr()
sum() aggregate function
table-valued functions in the FROM clause
tan()
tanh()
total() aggregate function
total_changes()
trim()
trunc()
typeof()
unicode()
unlikely()
upper()
zeroblob()
CLI
.archive command
.databases
.databases command
.dump
.excel
.expert command
.fullschema
.fullschema dot-command
.import
.mode
.mode quote
.once
.output
.parameter command
.read
.recover dot-command
.schema
.selftest dot-command
.sha3sum dot-command
.tables
CSV export
CSV import
Command Line Shell For SQLite
Export to excel
File I/O functions
ZIP file as database
dot-commands
edit()
C Interface
64-Bit Integer Types
A Handle To An Open BLOB
Add Content To A Dynamic String
Allowed return values from [sqlite3_txn_state()]
An Introduction To The SQLite C/C++ Interface
Application Defined Page Cache
Attempt To Free Heap Memory
Authorizer Action Codes
Authorizer Return Codes
Automatically Load Statically Linked Extensions
Binding Values To Prepared Statements
C/C++ Interface For SQLite Version 3
C/C++ Interface For SQLite Version 3 (old)
Cancel Automatic Extension Loading
Checkpoint Mode Values
Checkpoint a database
Checkpoint a database
Close A BLOB Handle
Closing A Database Connection
Collation Needed Callbacks
Column Names In A Result Set
Commit And Rollback Notification Callbacks
Compare the ages of two snapshot handles
Compile-Time Authorization Callbacks
Compile-Time Library Version Numbers
Compiling An SQL Statement
Configuration Options
Configure an auto-checkpoint
Configure database connections
Configuring The SQLite Library
Conflict resolution modes
Constants Defining Special Destructor Behavior
Convenience Routines For Running Queries
Copy And Free SQL Values
Core URI query parameters
Count The Number Of Rows Modified
Create A New Dynamic String Object
Create Or Redefine SQL Functions
Create and Destroy VFS Filenames
Custom Page Cache Object
Custom Page Cache Object
Data Change Notification Callbacks
Database Connection Configuration Options
Database Connection For Functions
Database Connection Handle
Database Connection Status
Database File Corresponding To A Journal
Database Snapshot
Declare The Schema Of A Virtual Table
Declared Datatype Of A Query Result
Define New Collating Sequences
Deprecated Functions
Deprecated Soft Heap Limit Interface
Deserialize a database
Destroy A Prepared Statement Object
Destroy a snapshot
Determine If A Prepared Statement Has Been Reset
Determine If An SQL Statement Is Complete
Determine If An SQL Statement Writes The Database
Determine If Virtual Table Column Access Is For UPDATE
Determine The Collation For a Virtual Table Constraint
Determine The Virtual Table Conflict Policy
Determine if a database is read-only
Determine the transaction state of a database
Device Characteristics
Dynamic String Object
Dynamically Typed Value Object
Enable Or Disable Extended Result Codes
Enable Or Disable Extension Loading
Enable Or Disable Shared Pager Cache
Error Codes And Messages
Error Logging Interface
Evaluate An SQL Statement
Experimental Interfaces
Extended Result Codes
Extract Metadata About A Column Of A Table
File Locking Levels
Finalize A Dynamic String
Find The Database Handle Of A Prepared Statement
Find the next prepared statement
Finding The Subtype Of SQL Values
Flags For File Open Operations
Flags for sqlite3_deserialize()
Flags for sqlite3_serialize
Flags for the xAccess VFS method
Flags for the xShmLock VFS method
Flush caches to disk mid-transaction
Formatted String Printing Functions
Free Memory Used By A Database Connection
Function Auxiliary Data
Function Flags
Fundamental Datatypes
Impose A Limit On Heap Size
Index Of A Parameter With A Given Name
Initialize The SQLite Library
Interrupt A Long-Running Query
Introduction
Last Insert Rowid
List Of SQLite Constants
List Of SQLite Functions
List Of SQLite Objects
Load An Extension
Loadable Extension Thunk
Low-Level Control Of Database Files
Low-level system error code
Maximum xShmLock index
Memory Allocation Routines
Memory Allocation Subsystem
Memory Allocator Statistics
Move a BLOB Handle to a New Row
Mutex Handle
Mutex Methods Object
Mutex Types
Mutex Verification Routines
Mutexes
Name Of A Host Parameter
Name Of The Folder Holding Database Files
Name Of The Folder Holding Temporary Files
Number Of Columns In A Result Set
Number Of SQL Parameters
Number of columns in a result set
OPEN_NOFOLLOW
OS Interface File Virtual Methods Object
OS Interface Object
OS Interface Open File Handle
Obtain Aggregate Function Context
Obtain Values For URI Parameters
Obtaining SQL Values
One-Step Query Execution Interface
Online Backup API
Online Backup Object
Open A BLOB For Incremental I/O
Opening A New Database Connection
Overload A Function For A Virtual Table
Prepare Flags
Prepared Statement Object
Prepared Statement Scan Status
Prepared Statement Scan Status Opcodes
Prepared Statement Status
Pseudo-Random Number Generator
Query Progress Callbacks
Query The EXPLAIN Setting For A Prepared Statement
Read Data From A BLOB Incrementally
Record A Database Snapshot
Recover snapshots from a wal file
Register A Callback To Handle SQLITE_BUSY Errors
Register A Virtual Table Implementation
Remove Unnecessary Virtual Table Implementations
Reset A Prepared Statement Object
Reset All Bindings On A Prepared Statement
Reset Automatic Extension Loading
Result Codes
Result Values From A Query
Retrieve the mutex for a database connection
Retrieving Statement SQL
Return The Filename For A Database Connection
Return The Size Of An Open BLOB
Run-Time Library Compilation Options Diagnostics
Run-Time Library Version Numbers
Run-Time Limit Categories
Run-time Limits
SQL Function Context Object
SQL Keyword Checking
SQL Trace Event Codes
SQL Trace Hook
SQLITE_CONFIG_COVERING_INDEX_SCAN
SQLITE_CONFIG_GETMALLOC
SQLITE_CONFIG_GETMUTEX
SQLITE_CONFIG_GETPCACHE
SQLITE_CONFIG_GETPCACHE2
SQLITE_CONFIG_HEAP
SQLITE_CONFIG_LOG
SQLITE_CONFIG_LOOKASIDE
SQLITE_CONFIG_MALLOC
SQLITE_CONFIG_MEMDB_MAXSIZE
SQLITE_CONFIG_MEMSTATUS
SQLITE_CONFIG_MMAP_SIZE
SQLITE_CONFIG_MULTITHREAD
SQLITE_CONFIG_MUTEX
SQLITE_CONFIG_PAGECACHE
SQLITE_CONFIG_PCACHE
SQLITE_CONFIG_PCACHE2
SQLITE_CONFIG_PCACHE_HDRSZ
SQLITE_CONFIG_PMASZ
SQLITE_CONFIG_SCRATCH
SQLITE_CONFIG_SERIALIZED
SQLITE_CONFIG_SINGLETHREAD
SQLITE_CONFIG_SMALL_MALLOC
SQLITE_CONFIG_SORTERREF_SIZE
SQLITE_CONFIG_SQLLOG
SQLITE_CONFIG_STMTJRNL_SPILL
SQLITE_CONFIG_URI
SQLITE_CONFIG_WIN32_HEAPSIZE
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBCONFIG_MAINDBNAME
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_WRITABLE_SCHEMA
SQLITE_DBSTATUS_CACHE_HIT
SQLITE_DBSTATUS_CACHE_MISS
SQLITE_DBSTATUS_CACHE_SPILL
SQLITE_DBSTATUS_CACHE_USED
SQLITE_DBSTATUS_CACHE_USED_SHARED
SQLITE_DBSTATUS_CACHE_WRITE
SQLITE_DBSTATUS_DEFERRED_FKS
SQLITE_DBSTATUS_LOOKASIDE_HIT
SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
SQLITE_DBSTATUS_LOOKASIDE_USED
SQLITE_DBSTATUS_SCHEMA_USED
SQLITE_DBSTATUS_STMT_USED
SQLITE_DETERMINISTIC
SQLITE_DIRECTONLY
SQLITE_FCNTL_BEGIN_ATOMIC_WRITE
SQLITE_FCNTL_BUSYHANDLER
SQLITE_FCNTL_CHUNK_SIZE
SQLITE_FCNTL_CKPT_DONE
SQLITE_FCNTL_CKPT_START
SQLITE_FCNTL_COMMIT_ATOMIC_WRITE
SQLITE_FCNTL_COMMIT_PHASETWO
SQLITE_FCNTL_DATA_VERSION
SQLITE_FCNTL_FILE_POINTER
SQLITE_FCNTL_HAS_MOVED
SQLITE_FCNTL_JOURNAL_POINTER
SQLITE_FCNTL_LOCKSTATE
SQLITE_FCNTL_LOCK_TIMEOUT
SQLITE_FCNTL_MMAP_SIZE
SQLITE_FCNTL_OVERWRITE
SQLITE_FCNTL_PERSIST_WAL
SQLITE_FCNTL_POWERSAFE_OVERWRITE
SQLITE_FCNTL_PRAGMA
SQLITE_FCNTL_RBU
SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE
SQLITE_FCNTL_SIZE_HINT
SQLITE_FCNTL_SIZE_LIMIT
SQLITE_FCNTL_SYNC
SQLITE_FCNTL_SYNC_OMITTED
SQLITE_FCNTL_TEMPFILENAME
SQLITE_FCNTL_TRACE
SQLITE_FCNTL_VFSNAME
SQLITE_FCNTL_VFS_POINTER
SQLITE_FCNTL_WAL_BLOCK
SQLITE_FCNTL_WIN32_AV_RETRY
SQLITE_FCNTL_WIN32_GET_HANDLE
SQLITE_FCNTL_WIN32_SET_HANDLE
SQLITE_FCNTL_ZIPVFS
SQLITE_INNOCUOUS
SQLITE_LIMIT_ATTACHED
SQLITE_LIMIT_COLUMN
SQLITE_LIMIT_COMPOUND_SELECT
SQLITE_LIMIT_EXPR_DEPTH
SQLITE_LIMIT_FUNCTION_ARG
SQLITE_LIMIT_LENGTH
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
SQLITE_LIMIT_SQL_LENGTH
SQLITE_LIMIT_TRIGGER_DEPTH
SQLITE_LIMIT_VARIABLE_NUMBER
SQLITE_LIMIT_VDBE_OP
SQLITE_LIMIT_WORKER_THREADS
SQLITE_PREPARE_NORMALIZE
SQLITE_PREPARE_NO_VTAB
SQLITE_PREPARE_PERSISTENT
SQLITE_SCANSTAT_EST
SQLITE_SCANSTAT_EXPLAIN
SQLITE_SCANSTAT_NAME
SQLITE_SCANSTAT_NLOOP
SQLITE_SCANSTAT_NVISIT
SQLITE_SCANSTAT_SELECTID
SQLITE_STATUS_MALLOC_COUNT
SQLITE_STATUS_MALLOC_SIZE
SQLITE_STATUS_MEMORY_USED
SQLITE_STATUS_PAGECACHE_OVERFLOW
SQLITE_STATUS_PAGECACHE_SIZE
SQLITE_STATUS_PAGECACHE_USED
SQLITE_STATUS_PARSER_STACK
SQLITE_STATUS_SCRATCH_OVERFLOW
SQLITE_STATUS_SCRATCH_SIZE
SQLITE_STATUS_SCRATCH_USED
SQLITE_STMTSTATUS_AUTOINDEX
SQLITE_STMTSTATUS_FULLSCAN_STEP
SQLITE_STMTSTATUS_MEMUSED
SQLITE_STMTSTATUS_REPREPARE
SQLITE_STMTSTATUS_RUN
SQLITE_STMTSTATUS_SORT
SQLITE_STMTSTATUS_VM_STEP
SQLITE_SUBTYPE
SQLITE_TRACE_CLOSE
SQLITE_TRACE_PROFILE
SQLITE_TRACE_ROW
SQLITE_TRACE_STMT
SQLITE_TXN_NONE
SQLITE_TXN_READ
SQLITE_TXN_WRITE
SQLITE_VTAB_CONSTRAINT_SUPPORT
SQLITE_VTAB_DIRECTONLY
SQLITE_VTAB_INNOCUOUS
SQLite Runtime Status
Serialize a database
Set A Busy Timeout
Set the Last Insert Rowid value
Setting The Result Of An SQL Function
Setting The Subtype Of An SQL Function
Source Of Data In A Query Result
Standard File Control Opcodes
Start a read transaction on an historical snapshot
Status Of A Dynamic String
Status Parameters
Status Parameters for database connections
Status Parameters for prepared statements
String Comparison
String Globbing
String LIKE Matching
Suspend Execution For A Short Time
Synchronization Type Flags
Test For Auto-Commit Mode
Test To See If The Library Is Threadsafe
Testing Interface
Testing Interface Operation Codes
Text Encodings
The C language interface to SQLite Version 2
The Carray() Table-Valued Function
The pre-update hook
Total Number Of Rows Modified
Tracing And Profiling Functions
Translate filenames
URI filename examples
URI filenames in sqlite3_open()
Unlock Notification
User Data For Functions
Virtual File System Objects
Virtual Table Configuration Options
Virtual Table Constraint Operator Codes
Virtual Table Cursor Object
Virtual Table Indexing Information
Virtual Table Instance Object
Virtual Table Interface Configuration
Virtual Table Object
Virtual Table Scan Flags
Win32 Directory Types
Win32 Specific Interface
Write Data Into A BLOB Incrementally
Write-Ahead Log Commit Hook
Zero Scan-Status Counters
byte-order determination rules
single-argument carray
sqlite3_backup_finish()
sqlite3_backup_init()
sqlite3_backup_pagecount()
sqlite3_backup_remaining()
sqlite3_backup_step()
sqlite3_carray_bind
sqlite3_vfs.xAccess
sqlite3_vfs.xOpen
xCachesize() page cache method
xCreate() page cache methods
xDestroy() page cache method
xFetch() page cache methods
xInit() page cache method
xPagecount() page cache methods
xRekey() page cache methods
xShrink() page cache method
xShutdown() page cache method
xUnpin() page cache method
C Interface: Session Module
Add A Changeset To A Changegroup
Advance A Changeset Iterator
Apply A Changeset To A Database
Attach A Table To A Session Object
Changegroup Handle
Changeset Iterator Handle
Concatenate Two Changeset Objects
Configure a changeset rebaser object
Configure global parameters
Constants Passed To The Conflict Handler
Constants Returned By The Conflict Handler
Create A New Changegroup Object
Create A New Session Object
Create An Iterator To Traverse A Changeset
Create a changeset rebaser object
Delete A Changegroup Object
Delete A Session Object
Delete a changeset rebaser object
Determine The Number Of Foreign Key Constraint Violations
Enable Or Disable A Session Object
Finalize A Changeset Iterator
Flags for sqlite3changeset_apply_v2
Flags for sqlite3changeset_start_v2
Generate A Changeset From A Session Object
Generate A Patchset From A Session Object
Invert A Changeset
List Of SQLite Constants
List Of SQLite Functions
List Of SQLite Objects
Load The Difference Between Tables Into A Session
Obtain A Composite Changeset From A Changegroup
Obtain Conflicting Row Values From A Changeset Iterator
Obtain The Current Operation From A Changeset Iterator
Obtain The Primary Key Definition Of A Table
Obtain new.* Values From A Changeset Iterator
Obtain old.* Values From A Changeset Iterator
Query for the amount of heap memory used by a session object
Rebase a changeset
Rebasing changesets
SQLite Session Module C/C++ Interface
Session Object Handle
Set Or Clear the Indirect Change Flag
Set a table filter on a Session Object
Streaming Versions of API functions
Test if a changeset has recorded any changes
The Session Extension
Values for sqlite3session_config()
changeset
patchset
Datatypes
Affinity Of Expressions
BINARY collating function
Boolean datatype
Collating function
Column affinity
Comparison affinity rules
Comparison expressions
Datatypes In SQLite Version 3
Datatypes In SQLite version 2
Date and time datatype
Expression affinity
How collation is determined
NOCASE collating function
RTRIM collating function
Rules for determining column affinity
Rules for determining column affinity in VIEWs
Sort order
Storage class
Type affinity
affinity
PRAGMA Statements
Encoding pragma
Exclusive locking mode
Fullfsync pragma
Optimize pragma
PRAGMA
PRAGMA analysis_limit
PRAGMA application_id
PRAGMA auto_vacuum
PRAGMA automatic_index
PRAGMA busy_timeout
PRAGMA cache_size
PRAGMA cache_spill
PRAGMA case_sensitive_like
PRAGMA cell_size_check
PRAGMA checkpoint_fullfsync
PRAGMA collation_list
PRAGMA compile_options
PRAGMA count_changes
PRAGMA data_store_directory
PRAGMA data_version
PRAGMA database_list
PRAGMA default_cache_size
PRAGMA defer_foreign_keys
PRAGMA empty_result_callbacks
PRAGMA encoding
PRAGMA foreign_key_check
PRAGMA foreign_key_list
PRAGMA foreign_keys
PRAGMA freelist_count
PRAGMA full_column_names
PRAGMA fullfsync
PRAGMA function
PRAGMA function_list
PRAGMA hard_heap_limit
PRAGMA ignore_check_constraints
PRAGMA incremental_vacuum
PRAGMA index_info
PRAGMA index_list
PRAGMA index_xinfo
PRAGMA integrity_check
PRAGMA journal_mode
PRAGMA journal_size_limit
PRAGMA legacy_alter_table
PRAGMA legacy_file_format
PRAGMA locking_mode
PRAGMA max_page_count
PRAGMA mmap_size
PRAGMA module_list
PRAGMA optimize
PRAGMA page_count
PRAGMA page_size
PRAGMA parser_trace
PRAGMA pragma_list
PRAGMA query_only
PRAGMA quick_check
PRAGMA read_uncommitted
PRAGMA recursive_triggers
PRAGMA reverse_unordered_selects
PRAGMA schema_version
PRAGMA secure_delete
PRAGMA short_column_names
PRAGMA shrink_memory
PRAGMA soft_heap_limit
PRAGMA stats
PRAGMA synchronous
PRAGMA table_info
PRAGMA table_xinfo
PRAGMA temp_store
PRAGMA temp_store_directory
PRAGMA threads
PRAGMA trusted_schema
PRAGMA user_version
PRAGMA vdbe_addoptrace
PRAGMA vdbe_debug
PRAGMA vdbe_listing
PRAGMA vdbe_trace
PRAGMA wal_autocheckpoint
PRAGMA wal_checkpoint
PRAGMA writable_schema
Persistent journal mode
Pragma list
Pragma statements supported by SQLite
Stats pragma
Synchronous pragma
Threads pragma
analysis_limit pragma
application_id pragma
auto_vacuum pragma
automatic_index pragma
busy_timeout pragma
cache_size pragma
cache_spill pragma
case_sensitive_like pragma
cell_size_check pragma
checkpoint_fullfsync pragma
collation_list pragma
compile_options pragma
count_changes pragma
data_store_directory pragma
data_version pragma
database_list pragma
default_cache_size pragma
defer_foreign_keys pragma
empty_result_callbacks pragma
foreign_key_check pragma
foreign_key_list pragma
foreign_keys pragma
freelist_count pragma
full_column_names pragma
function_list pragma
hard_heap_limit pragma
ignore_check_constraints pragma
incremental_vacuum pragma
index_info pragma
index_list pragma
index_xinfo pragma
integrity_check pragma
journal_mode pragma
journal_size_limit pragma
legacy_alter_table pragma
legacy_file_format pragma
locking_mode pragma
max_page_count pragma
mmap_size pragma
module_list pragma
page_count pragma
page_size pragma
parser_trace pragma
pragma_list pragma
query_only pragma
quick_check pragma
read_uncommitted pragma
recursive_triggers pragma
reverse_unordered_selects pragma
schema_version pragma
secure_delete pragma
short_column_names pragma
shrink_memory pragma
soft_heap_limit pragma
table_info pragma
table_xinfo pragma
temp_store pragma
temp_store_directory pragma
trusted_schema pragma
user_version pragma
vdbe_addoptrace pragma
vdbe_debug pragma
vdbe_listing pragma
vdbe_trace pragma
wal_autocheckpoint pragma
wal_checkpoint pragma
writable_schema pragma
Database File Format
Application ID
B*-Trees
B-tree
Cell format summary
Cell payload
Change counter
Database File Format
Database File Format
Database header
File format version numbers
Hot journal
Hot journal files
Index b-tree
Internal index
Internal indexes
Internal schema object
Internal table
Overflow page
Record format
Reserve bytes
Reset the WAL
Rollback journal format
Schema format
Schema format number
Schema storage
Serial type
Table b-tree
Text encoding
Usable size
WAL checksum algorithm
WAL file format
WAL format
WAL read algorithm
WAL reset
free-page list
freelist
in-header database size
lock-byte page
sqlite_sequence
sqlite_stat1
sqlite_stat2
sqlite_stat3
sqlite_stat4
variable-length integer
varint
version-valid-for number
Tcl Interface
Authorizer method
Backup method
Busy method
Cache method
Changes method
Close method
Collate method
Complete method
Config method
Copy method
Deserialize method
Errorcode method
Eval method
Exists method
Function method
Incrblob method
Interrupt method
Nullvalue method
Onecolumn method
Profile method
Progress method
Restore method
Serialize method
Status method
TCL interface authorizer method
TCL interface backup method
TCL interface bind_fallback method
TCL interface busy method
TCL interface cache method
TCL interface changes method
TCL interface close method
TCL interface collate method
TCL interface collation_needed method
TCL interface commit_hook method
TCL interface complete method
TCL interface config method
TCL interface copy method
TCL interface deserialize method
TCL interface enable_load_extension method
TCL interface errorcode method
TCL interface eval method
TCL interface exists method
TCL interface function method
TCL interface incrblob method
TCL interface interrupt method
TCL interface last_insert_rowid method
TCL interface nullvalue method
TCL interface onecolumn method
TCL interface profile method
TCL interface progress method
TCL interface restore method
TCL interface rollback_hook method
TCL interface serialize method
TCL interface status method
TCL interface timeout method
TCL interface total_changes method
TCL interface trace method
TCL interface trace_v2 method
TCL interface transaction method
TCL interface unlock_notify method
TCL interface update_hook method
TCL interface version method
TCL interface wal_hook method
TCL variable substitution
The Tcl interface to the SQLite library
Timeout method
Trace method
Transaction method
Version method
bind_fallback method
collation_needed method
commit_hook method
enable_load_extension method
last_insert_rowid method
rollback_hook method
total_changes method
trace_v2 method
unlock_notify method
update_hook method
wal_hook method
Query Planner
Automatic indexes
Automatic indexing
Block sorting
CROSS JOIN
Covering index
Covering indices
Flattening optimization
Hazards of upgrading to the NGQP
Join order
LEFT JOIN strength reduction optimization
LIKE optimization
Manual Control Of Query Plans Using CROSS JOIN
Manual Control Of Query Plans Using SQLITE_STAT Tables
Or optimization
Partial sorting by index
QPSG
Query Planning
Query flattener
Query planner checklist
Query planner stability guarantee
Range query optimization
Sorting subsets of the result
Subquery co-routines
The Fossil NGQP Upgrade Case Study
The Next-Generation Query Planner
The SQLite Query Optimizer Overview
co-routines
flattened
min/max optimization
omit-left-join optimization
or-connected-terms
push-down optimization
skip-scan
skip-scan optimization
sorting
strategies
R*Tree Module
Auxiliary columns in r-tree tables
Custom r-tree queries
Reading and writing an rtree at the same time
Rtree shadow tables
The SQLite R*Tree Module
integer-valued r-trees
rtreecheck()
sqlite3_rtree_query_callback
xQueryFunc R*Tree callback
Dynamic Memory Allocation
Debugging memory allocator
Default memory allocator
Dynamic Memory Allocation In SQLite
Experimental memory allocators
Lookaside buffer
Lookaside memory
Lookaside memory allocator
Memory statistics
Pagecache memory allocator
Robson proof
Win32 native memory allocator
built-in memory allocators
lookaside
zero-malloc memory allocator
How To Corrupt
Database filename aliasing
Deleting a hot journal
Filesystem corruption
How To Corrupt An SQLite Database File
Separating a database from its journal
Stale file descriptor
Unlink corruption
Unlinked database files
cfgerrors*
Foreign Key Constraints
Child key
Child table
Foreign key actions
Foreign key constraints are enabled
Parent key
Parent table
SQLite Foreign Key Support
Virtual Table Mechanism
Custom virtual tables
Eponymous virtual table
Hidden column
List Of Virtual Tables
Shadow tables
The Virtual Table Mechanism Of SQLite
WITHOUT ROWID virtual table
colUsed field
eponymous-only virtual table
sqlite3_module.xBegin
sqlite3_module.xBestIndex
sqlite3_module.xClose
sqlite3_module.xColumn
sqlite3_module.xCommit
sqlite3_module.xConnect
sqlite3_module.xCreate
sqlite3_module.xDisconnect
sqlite3_module.xEof
sqlite3_module.xFilter
sqlite3_module.xFindFunction
sqlite3_module.xNext
sqlite3_module.xOpen
sqlite3_module.xRename
sqlite3_module.xRollback
sqlite3_module.xRowid
sqlite3_module.xSavepoint
sqlite3_module.xShadowName
sqlite3_module.xSync
sqlite3_module.xUpdate
table-valued function
xBegin
xBestIndex
xColumn
xCommit
xConnect
xCreate
xDestroy
xDisconnect
xEof
xFilter
xFindFunction
xNext
xRelease
xRename
xRollback
xRollbackTo
xRowid
xSavepoint
xShadowName
xUpdate
Locking and Concurrency
File Locking And Concurrency In SQLite Version 3
File locking states
How To Corrupt Your Database Files
Rollback journal
Writer starvation
ext3 barrier problem
Geopoly
The Geopoly Interface To The SQLite R*Tree Module
geopoly_area
geopoly_bbox
geopoly_blob
geopoly_ccw
geopoly_contains_point
geopoly_group_bbox
geopoly_json
geopoly_overlap
geopoly_regular
geopoly_svg
geopoly_within
geopoly_xform
Limits
Implementation Limits For SQLite
SQLITE_MAX_ATTACHED
SQLITE_MAX_COLUMN
SQLITE_MAX_COMPOUND_SELECT
SQLITE_MAX_EXPR_DEPTH
SQLITE_MAX_FUNCTION_ARG
SQLITE_MAX_LENGTH
SQLITE_MAX_LIKE_PATTERN_LENGTH
SQLITE_MAX_PAGE_COUNT
SQLITE_MAX_SQL_LENGTH
SQLITE_MAX_TRIGGER_DEPTH
SQLITE_MAX_VARIABLE_NUMBER
JSON
JSON function path arguments
JSON paths
The JSON1 Extension
json
json_array
json_array_length
json_each
json_each table-valued function
json_extract
json_group_array
json_group_object
json_insert
json_object
json_patch
json_quote
json_remove
json_replace
json_set
json_tree
json_tree table-valued function
json_type
json_valid
RBU Extension
RBU Database Contents
RBU Database Tables
RBU FTS3/4 Tables
RBU Update
RBU Vacuum
Sqldiff --rbu
The RBU Extension
Syntax Diagrams
SQLite Syntax: aggregate-function-invocation
SQLite Syntax: alter-table-stmt
SQLite Syntax: analyze-stmt
SQLite Syntax: attach-stmt
SQLite Syntax: begin-stmt
SQLite Syntax: column-constraint
SQLite Syntax: column-def
SQLite Syntax: column-name-list
SQLite Syntax: comment-syntax
SQLite Syntax: commit-stmt
SQLite Syntax: common-table-expression
SQLite Syntax: compound-operator
SQLite Syntax: compound-select-stmt
SQLite Syntax: conflict-clause
SQLite Syntax: create-index-stmt
SQLite Syntax: create-table-stmt
SQLite Syntax: create-trigger-stmt
SQLite Syntax: create-view-stmt
SQLite Syntax: create-virtual-table-stmt
SQLite Syntax: cte-table-name
SQLite Syntax: delete-stmt
SQLite Syntax: delete-stmt-limited
SQLite Syntax: detach-stmt
SQLite Syntax: drop-index-stmt
SQLite Syntax: drop-table-stmt
SQLite Syntax: drop-trigger-stmt
SQLite Syntax: drop-view-stmt
SQLite Syntax: expr
SQLite Syntax: factored-select-stmt
SQLite Syntax: filter-clause
SQLite Syntax: foreign-key-clause
SQLite Syntax: frame-spec
SQLite Syntax: indexed-column
SQLite Syntax: insert-stmt
SQLite Syntax: join-clause
SQLite Syntax: join-constraint
SQLite Syntax: join-operator
SQLite Syntax: literal-value
SQLite Syntax: numeric-literal
SQLite Syntax: ordering-term
SQLite Syntax: over-clause
SQLite Syntax: pragma-stmt
SQLite Syntax: pragma-value
SQLite Syntax: qualified-table-name
SQLite Syntax: raise-function
SQLite Syntax: recursive-cte
SQLite Syntax: reindex-stmt
SQLite Syntax: release-stmt
SQLite Syntax: result-column
SQLite Syntax: returning-clause
SQLite Syntax: rollback-stmt
SQLite Syntax: savepoint-stmt
SQLite Syntax: select-core
SQLite Syntax: select-stmt
SQLite Syntax: signed-number
SQLite Syntax: simple-function-invocation
SQLite Syntax: simple-select-stmt
SQLite Syntax: sql-stmt
SQLite Syntax: sql-stmt-list
SQLite Syntax: table-constraint
SQLite Syntax: table-or-subquery
SQLite Syntax: type-name
SQLite Syntax: update-stmt
SQLite Syntax: update-stmt-limited
SQLite Syntax: upsert-clause
SQLite Syntax: vacuum-stmt
SQLite Syntax: window-defn
SQLite Syntax: window-function-invocation
SQLite Syntax: with-clause
Syntax Diagrams For SQLite
Copyright ©2025 TypeError Powered By AnyPost, page cost 88ms.
Privacy Policy