with-clause
SQLite is in the Public Domain.
https://sqlite.org/syntax/with-clause.html
| Name | SQLite |
| Version | |
| Badge |
|
| Last Updated | 2022-02-23T19:34:30Z |
Table of Contents
-
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
- Autovacuum Compaction Amount Callback
- Binding Values To Prepared Statements
- byte-order determination rules
- C/C++ Interface For SQLite Version 3
- C/C++ Interface For SQLite Version 3 (old)
- Cancel Automatic Extension Loading
- Checkpoint a database
- Checkpoint a database
- Checkpoint Mode Values
- 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
- Constraint values in xBestIndex()
- 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 and Destroy VFS Filenames
- Create Or Redefine SQL Functions
- 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 database is read-only
- Determine If A Prepared Statement Has Been Reset
- Determine if a virtual table query is DISTINCT
- 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 transaction state of a database
- Determine The Virtual Table Conflict Policy
- 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 all elements on the right-hand side of an IN constraint
- 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
- Identify and handle IN constraints in xBestIndex
- 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 Columns In A Result Set
- Number Of SQL Parameters
- 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
- OPEN_EXRESCODE
- OPEN_NOFOLLOW
- Opening A New Database Connection
- OS Interface File Virtual Methods Object
- OS Interface Object
- OS Interface Open File Handle
- 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
- 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
- single-argument carray
- Source Of Data In A Query Result
- SQL Function Context Object
- SQL Keyword Checking
- SQL Trace Event Codes
- SQL Trace Hook
- SQLite Runtime Status
- sqlite3_backup_finish()
- sqlite3_backup_init()
- sqlite3_backup_pagecount()
- sqlite3_backup_remaining()
- sqlite3_backup_step()
- sqlite3_carray_bind
- sqlite3_vfs.xAccess
- sqlite3_vfs.xOpen
- 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_CKSM_FILE
- SQLITE_FCNTL_COMMIT_ATOMIC_WRITE
- SQLITE_FCNTL_COMMIT_PHASETWO
- SQLITE_FCNTL_DATA_VERSION
- SQLITE_FCNTL_EXTERNAL_READER
- SQLITE_FCNTL_FILE_POINTER
- SQLITE_FCNTL_HAS_MOVED
- SQLITE_FCNTL_JOURNAL_POINTER
- SQLITE_FCNTL_LOCK_TIMEOUT
- SQLITE_FCNTL_LOCKSTATE
- 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_VFS_POINTER
- SQLITE_FCNTL_VFSNAME
- 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_NO_VTAB
- SQLITE_PREPARE_NORMALIZE
- 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_FILTER HIT
- SQLITE_STMTSTATUS_FILTER_MISS
- 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
- 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
- Unlock Notification
- URI filename examples
- URI filenames in sqlite3_open()
- 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
- 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
- Zero Scan-Status Counters
-
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
- 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 changeset rebaser object
- Create A New Changegroup Object
- Create A New Session Object
- Create An Iterator To Traverse A Changeset
- Delete A Changegroup Object
- Delete a changeset rebaser object
- Delete A Session 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 new.* Values From A Changeset Iterator
- Obtain old.* Values From A Changeset Iterator
- Obtain The Current Operation From A Changeset Iterator
- Obtain The Primary Key Definition Of A Table
- patchset
- Query for the amount of heap memory used by a session object
- Rebase a changeset
- Rebasing changesets
- Return An Upper-limit For The Size Of The Changeset
- Session Object Handle
- Set a table filter on a Session Object
- Set Or Clear the Indirect Change Flag
- SQLite Session Module C/C++ Interface
- Streaming Versions of API functions
- Test if a changeset has recorded any changes
- The Session Extension
- Values for sqlite3session_config()
-
CLI
- .archive command
- .connection
- .databases
- .databases command
- .dump
- .excel
- .expert command
- .fullschema
- .fullschema dot-command
- .import
- .import command
- .load command
- .mode
- .mode quote
- .once
- .open
- .open command
- .output
- .parameter command
- .read
- .recover dot-command
- .schema
- .selftest dot-command
- .sha3sum dot-command
- .tables
- Columnar output modes
- Command Line Shell For SQLite
- command-line options
- CSV export
- CSV import
- dot-commands
- edit()
- Export to excel
- File I/O functions
- Output mode
- qbox
- Qbox output mode
- Safe command-line option
- Wrapping text
- ZIP file as database
-
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
- free-page list
- freelist
- Hot journal
- Hot journal files
- in-header database size
- Index b-tree
- Internal index
- Internal indexes
- Internal schema object
- Internal table
- lock-byte page
- Overflow page
- Record format
- Reserve bytes
- Reset the WAL
- Rollback journal format
- Schema format
- Schema format number
- Schema storage
- Serial type
- sqlite_sequence
- sqlite_stat1
- sqlite_stat2
- sqlite_stat3
- sqlite_stat4
- Table b-tree
- Text encoding
- Usable size
- variable-length integer
- varint
- version-valid-for number
- WAL checksum algorithm
- WAL file format
- WAL format
- WAL read algorithm
- WAL reset
-
Datatypes
- affinity
- Affinity in compound VIEWs
- Affinity Of Expressions
- BINARY collating function
- Boolean datatype
- Collating function
- Column affinity
- Comparison affinity rules
- Comparison expressions
- Datatypes In SQLite
- 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
-
Dynamic Memory Allocation
- built-in memory allocators
- Debugging memory allocator
- Default memory allocator
- Dynamic Memory Allocation In SQLite
- Experimental memory allocators
- lookaside
- Lookaside buffer
- Lookaside memory
- Lookaside memory allocator
- Memory statistics
- Pagecache memory allocator
- Robson proof
- Win32 native memory allocator
- zero-malloc memory allocator
- Foreign Key Constraints
-
Full-Text Search
- "automerge" command
- "merge" command
- "optimize" command
- "rebuild" command
- Auxiliary function mapping
- bugs
- commands
- 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 auxiliary functions
- FTS hidden column
- FTS MATCH
- FTS shadow tables
- fts3_tokenizer
- fts3tokenize
- fts3tokenize virtual table
- FTS4
- FTS4 "automerge" command
- FTS4 "integrity-check" command
- FTS4 "merge" command
- FTS4 "optimize" command
- FTS4 "rebuild" command
- FTS4 commands
- fts4 compress option
- FTS4 content option
- FTS4 languageid option
- FTS4 matchinfo option
- FTS4 notindexed option
- FTS4 options
- FTS4 order option
- FTS4 prefix option
- fts4aux
- fts4aux languageid column
- 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 CREATE TABLE Options
- 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 NEAR queries
- FTS5 optimize command
- FTS5 pgsz option
- FTS5 Phrases
- FTS5 prefix indexes
- FTS5 prefix queries
- FTS5 query syntax
- FTS5 rank configuration option
- FTS5 rebuild command
- fts5 shadow tables
- FTS5 snippet
- FTS5 Strings
- fts5 technical differences
- FTS5 tokenizers
- FTS5 usermerge option
- fts5vocab
- languageid
- matchinfo
- Matchinfo b flag
- Matchinfo x flag
- Matchinfo y flag
- NEAR queries
- Phrase queries
- Prefix queries
- Prefix query
- Search application tips
- Segment btree
- shadowtabs
- Simple fts queries
- snippet
- SQLite FTS3 and FTS4 Extensions
- SQLite FTS5 Extension
- tokenizer
- Trigram indexes
- Trigram tokenizer
- unicode61
- unindexed
- Geopoly
- How To Corrupt
-
JSON
- -> and ->> operators
- -> operator
- json
- JSON function path arguments
- JSON Functions And Operators
- JSON paths
- 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
- Value argument
-
Language
- 'utc' modifier
- abs()
- acos()
- acosh()
- Add column
- ALTER TABLE
- ALTER TABLE ADD COLUMN
- ALTER TABLE DROP COLUMN
- ALTER TABLE RENAME
- ALTER TABLE RENAME COLUMN
- ALTER TABLE RENAME documentation
- ANALYZE
- Approximate ANALYZE
- asin()
- asinh()
- atan()
- atan2()
- atanh()
- ATTACH DATABASE
- Auto modifier
- Automatically running ANALYZE
- avg() aggregate function
- Bare aggregate terms
- BEGIN EXCLUSIVE
- BEGIN IMMEDIATE
- BETWEEN
- Binary operators
- Boolean expression
- Bound parameter
- Built-in Aggregate Functions
- Built-In Mathematical SQL Functions
- Built-In Scalar SQL Functions
- CASE expression
- CAST
- CAST expression
- CAST operator
- ceil
- ceiling
- changes()
- char()
- CHECK
- CHECK constraint
- coalesce()
- COLLATE
- COLLATE clause
- COLLATE constraint
- COLLATE operator
- Column definition
- Compound query
- Compound select
- Compute the Mandelbrot set
- Correlated subqueries
- cos()
- cosh()
- count() aggregate function
- CREATE INDEX
- CREATE TABLE
- CREATE TABLE AS
- CREATE TRIGGER
- CREATE VIEW
- CREATE VIRTUAL TABLE
- Database Object Name Resolution
- Date And Time Functions
- date/time modifiers
- DEFAULT clauses
- Default column value
- Default value
- degrees()
- DELETE
- DESC
- Descending index
- Descending indexes
- Descending indices
- DETACH
- DISTINCT
- Drop column
- DROP INDEX
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- ESCAPE
- EXISTS operator
- exp()
- EXPLAIN
- extract
- FILTER clause on aggregate functions
- floor()
- format()
- FROM clause
- Generalized ALTER TABLE procedure
- glob()
- GROUP BY
- group_concat() aggregate function
- hex()
- Hexadecimal integer literals
- Hexadecimal integers
- How vacuum works
- ifnull()
- iif()
- IN operator
- INSERT
- INSTEAD OF
- INSTEAD OF trigger
- instr()
- INTEGER PRIMARY KEY
- IS NOT operator
- IS operator
- Julianday modifier
- last_insert_rowid()
- length()
- like()
- likelihood()
- likely()
- LIMIT
- Literal value
- ln()
- load_extension()
- Localtime modifier
- log
- log10
- log2()
- lower()
- ltrim()
- MATCH
- Materialization hints
- MATERIALIZED
- max()
- max() aggregate function
- min()
- min() aggregate function
- mod()
- modifiers
- NOT EXISTS operator
- NOT IN operator
- NOT MATERIALIZED
- NOT NULL
- NOT NULL constraint
- nullif()
- NULLS FIRST
- NULLS LAST
- OFFSET
- ORDER BY
- Ordinary common table expressions
- parameter
- pi()
- pow()
- PRIMARY KEY
- PRIMARY KEY constraint
- printf()
- Queries against graphs
- Query Language Understood by SQLite
- quote()
- radians()
- RAISE function
- random()
- randomblob()
- Recommended ANALYZE usage pattern
- Recursive common table expression
- Recursive query
- REGEXP
- REINDEX
- Rename column
- Rename table
- REPLACE
- replace()
- result-set expressions
- RETURNING
- round()
- ROWID
- rtrim()
- Savepoints
- SELECT
- sign()
- Simple SELECT
- sin()
- sinh()
- Solve Sudoku puzzles
- soundex()
- SQL Comment Syntax
- SQL Language Expressions
- SQLite Keywords
- sqlite_compileoption_get()
- sqlite_compileoption_used()
- sqlite_offset()
- sqlite_source_id()
- sqlite_version()
- sqrt()
- Subqueries
- substr()
- sum() aggregate function
- table-valued functions in the FROM clause
- tan()
- tanh()
- TEMP triggers on non-TEMP tables
- The INDEXED BY Clause
- The ON CONFLICT Clause
- The WITH Clause
- total() aggregate function
- total_changes()
- Transaction
- Treats the CROSS JOIN operator specially
- trim()
- trunc()
- Truncate optimization
- typeof()
- Undefined BEFORE trigger behavior
- unicode()
- UNIQUE
- Unique constraint
- Unique index
- unixepoch() function
- unlikely()
- UPDATE
- UPDATE FROM
- upper()
- UPSERT
- UPSERT parsing ambiguity
- VACUUM
- VACUUM INTO
- VALUES
- VALUES clause
- WHERE clause
- Why ALTER TABLE is so difficult
- zeroblob()
- Limits
- Locking and Concurrency
-
Miscellaneous
- %q
- %w
- %z
- .imposter dot-command
- 35% Faster Than The Filesystem
- 8+3 Filenames
- Adding to Zip
- advanced
- Aggregate window functions
- An Asynchronous I/O Module For SQLite
- application-defined function attacks
- Application-Defined SQL Functions
- application-defined window 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
- built-in window functions
- built-ins
- 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
- compilation
- 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
- Database as container object
- Database as object
- Database corruption caused by inconsistent use of 8+3 filenames
- date/time special case
- DBSTAT aggregated mode
- Decimal extension
- Defense Against The Dark Arts
- Deterministic SQL Functions
- Distinctive Features Of SQLite
- double-quoted string literal
- editdist3
- Exclude clause
- EXPLAIN QUERY PLAN
- Extended error code
- Extended result code
- Features Of SQLite
- File Format Changes in SQLite
- Floating Point Numbers
- Frame boundary
- Frame specification
- Frame type
- frames
- Full-Featured SQL
- Generated Columns
- GROUPS frames
- High Reliability
- Hints for Debugging SQLite
- How SQLite Is Tested
- How SQLite Works
- How To Compile SQLite
- How To Download Canonical SQLite Source Code
- ieee754 extension
- ieee754() function
- ieee754_exponent() function
- ieee754_from_blob() function
- ieee754_mantissa() function
- ieee754_to_blob() function
- Imposter Tables
- In-Memory Databases
- in-memory shared cache database
- in-memory shared-cache
- Indexes On Expressions
- Internal Versus External BLOBs
- Invalid UTF Policy
- 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
- microoptimizations
- Missing callback
- Mutation test script
- NUL Characters In Strings
- NULL Handling in SQLite
- Opcode definitions
- Openclose callback
- Partial Indexes
- partition
- Persistent loadable extensions
- Pointer leak
- Pointer Passing Interfaces
- 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
- shims
- Split amalgamation
- SQL Features That SQLite Does Not Implement
- sqldiff.exe: Database Difference Utility
- 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 a Self Contained System
- 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's Built-in printf()
- SQLite: Single File Database
- Statement journal
- STRICT Tables
- subprograms
- super-journal
- swarmvtab
- Swarmvtab context
- Swarmvtab Virtual Table
- Temporary databases
- Temporary directory search algorithm
- Temporary Files Used By SQLite
- Temporary tables
- TH3
- The Advantages Of Flexible Typing
- The Bytecode() And Tables_Used() Table-Valued Functions
- The Checksum VFS Shim
- The COMPLETION() Table-Valued Function
- The CSV Virtual Table
- The dbhash.exe Utility Program
- The DBSTAT Virtual Table
- The Error And Warning Log
- The generate_series Table-Valued Function
- The Lemon LALR(1) Parser Generator
- The Schema Table
- The Spellfix1 Virtual Table
- The SQLite Amalgamation
- The SQLite Bytecode Engine
- The SQLite OS Interface or "VFS"
- The SQLite Zipfile Module
- The sqlite3_analyzer.exe Utility Program
- The SQLITE_DBPAGE Virtual Table
- The SQLITE_MEMSTAT Virtual Table
- The SQLITE_STMT Virtual Table
- The UINT Collating Sequence
- The UNION Virtual Table
- The Use Of assert() In SQLite
- The Virtual Database Engine of SQLite
- Things That Can Go Wrong
- Torn page
- Uniform Resource Identifiers
- Untrusted database files
- user-defined window functions
- Using SQLite In Multi-Threaded Applications
- Version Numbers in SQLite
- VFS shim
- Vulnerabilities
- What If OpenDocument Used SQLite?
- When to use WITHOUT ROWID
- Why Is SQLite Coded In C
- Why SQLite Does Not Use Git
- Window chaining
- Window Functions
- Zero-Configuration
-
PRAGMA Statements
- 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
- Exclusive locking mode
- foreign_key_check pragma
- foreign_key_list pragma
- foreign_keys pragma
- freelist_count pragma
- full_column_names pragma
- Fullfsync 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
- Persistent journal mode
- 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 list
- 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 statements supported by SQLite
- PRAGMA stats
- PRAGMA synchronous
- PRAGMA table_info
- PRAGMA table_list
- 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
- 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_list 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 pragma
-
Query Planner
- Automatic indexes
- Automatic indexing
- Block sorting
- co-routines
- constant-propagation optimization
- Covering index
- Covering indices
- CROSS JOIN
- flattened
- Flattening optimization
- Hash join
- 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
- min/max optimization
- omit-left-join optimization
- Or optimization
- or-connected-terms
- Partial sorting by index
- push-down optimization
- QPSG
- Query flattener
- Query planner checklist
- Query planner stability guarantee
- Query Planning
- Range query optimization
- skip-scan
- skip-scan optimization
- sorting
- Sorting subsets of the result
- strategies
- Subquery co-routines
- The Fossil NGQP Upgrade Case Study
- The Next-Generation Query Planner
- The SQLite Query Optimizer Overview
- R*Tree Module
- 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-options
- 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
-
Tcl Interface
- Authorizer method
- Backup method
- bind_fallback method
- Busy method
- Cache method
- Changes method
- Close method
- Collate method
- collation_needed method
- commit_hook method
- Complete method
- Config method
- Copy method
- Deserialize method
- enable_load_extension method
- Errorcode method
- Eval method
- Exists method
- Function method
- Incrblob method
- Interrupt method
- last_insert_rowid method
- Nullvalue method
- Onecolumn method
- Profile method
- Progress method
- Restore method
- rollback_hook 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
- total_changes method
- Trace method
- trace_v2 method
- Transaction method
- unlock_notify method
- update_hook method
- Version method
- wal_hook method
-
Virtual Table Mechanism
- colUsed field
- Custom virtual tables
- Eponymous virtual table
- eponymous-only virtual table
- Hidden column
- List Of Virtual Tables
- orderByConsumed
- Shadow tables
- 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
- The Virtual Table Mechanism Of SQLite
- WITHOUT ROWID virtual table
- xBegin
- xBestIndex
- xColumn
- xCommit
- xConnect
- xCreate
- xDestroy
- xDisconnect
- xEof
- xFilter
- xFindFunction
- xNext
- xRelease
- xRename
- xRollback
- xRollbackTo
- xRowid
- xSavepoint
- xShadowName
- xUpdate
-
Write-Ahead Logging
- "shm" file
- Advantages of WAL-mode
- Avoiding large WAL files
- checkpoint
- checkpointed
- checkpointing
- Large WAL files
- mxFrame
- nBackfill
- read-only WAL databases
- recovery
- WAL backwards compatibility
- WAL concurrency
- WAL file
- WAL without shared memory
- wal-index
- WAL-index File Format
- WAL-index format
- WAL-mode crash recovery
- WAL-mode File Format
- WAL-mode locks
- WAL-mode read blocking
- Write-Ahead Logging