1. Overview SQLite supports three different threading modes: Single-thread. In this mode, all mutexes are disabled and SQLite is unsafe to use in more than a single thread at once. Multi-thread. In this mode, SQLite can be safely used by ... 

1. Overview The INSERT statement comes in three basic forms. INSERT INTO table VALUES(...); The first form (with the "VALUES" keyword) creates one or more new rows in an existing table. If the column-name list after table-name is ... 

1. Overview Carray() is a table-valued function with a single column (named "value") and zero or more rows. The "value" of each row in the carray() is taken from a C-language array supplied by the application via parameter binding. In ... 

1. Overview The CSV virtual table reads RFC 4180 formatted comma-separated values, and returns that content as if it were rows and columns of an SQL table. The CSV virtual table is useful to applications that need to bulk-load large ... 

1. Overview The math functions shown below are a subgroup of scalar functions that are built into the SQLite amalgamation source file but are only active if the amalgamation is compiled using the -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option. The arguments to ... 

1. Overview The SQLITE_STMT extension implements an eponymous-only virtual table that provides information about all prepared statements associated with the database connection. The SQLITE_STMT extension is included in the amalgamation though it is disabled by default. Use the SQLITE_ENABLE_STMTVTAB compile-time ... 

1. Overview The DELETE command removes records from the table identified by the . If the WHERE clause is not present, all records in the table are deleted. If a WHERE clause is supplied, then only those rows for which the ... 

1. Overview SQL functions in SQLite can be either "deterministic" or "non-deterministic". A deterministic function always gives the same answer when it has the same inputs. Most built-in SQL functions in SQLite are deterministic. For example, the abs(X) function ... 

1. Overview The checksum VFS extension is a VFS shim that adds an 8-byte checksum to the end of every page in an SQLite database. The checksum is added as each page is written and verified as each page is read ... 

1. Overview The SQL language parser for SQLite is generated using a code-generator program called "Lemon". The Lemon program reads a grammar of the input language and emits C-code to implement a parser for that language.