From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/lang.html | 433 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 433 insertions(+) create mode 100644 www/lang.html (limited to 'www/lang.html') diff --git a/www/lang.html b/www/lang.html new file mode 100644 index 0000000..ae4357c --- /dev/null +++ b/www/lang.html @@ -0,0 +1,433 @@ + + + + + +Query Language Understood by SQLite + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ + + +

SQL As Understood By SQLite

+ +

SQLite understands most of the standard SQL +language. But it does omit some features +while at the same time +adding a few features of its own. This document attempts to +describe precisely what parts of the SQL language SQLite does +and does not support. A list of SQL keywords is +also provided. The SQL language syntax is described by +syntax diagrams. + +

The following syntax documentation topics are available:

+ + +
+ +

The routines sqlite3_prepare_v2(), sqlite3_prepare(), +sqlite3_prepare16(), sqlite3_prepare16_v2(), +sqlite3_exec(), and sqlite3_get_table() accept +an SQL statement list (sql-stmt-list) which is a semicolon-separated +list of statements.

+ +

sql-stmt-list:

+
+ + + + + +sql-stmt + + + + + + + + +; + + + + +
+
+ + +

Each SQL statement in the statement list is an instance of the +following:

+ +

sql-stmt:

+
+ + + + +EXPLAIN + + + +QUERY + + + +PLAN + + + + + + + + + +alter-table-stmt + + + + + + +analyze-stmt + + + + + + +attach-stmt + + + + + + +begin-stmt + + + + + + +commit-stmt + + + + + + +create-index-stmt + + + + + + +create-table-stmt + + + + + + +create-trigger-stmt + + + + + + +create-view-stmt + + + + + + +create-virtual-table-stmt + + + + + + +delete-stmt + + + + + + +delete-stmt-limited + + + + + + +detach-stmt + + + + + + +drop-index-stmt + + + + + + +drop-table-stmt + + + + + + +drop-trigger-stmt + + + + + + +drop-view-stmt + + + + + + +insert-stmt + + + + + + +pragma-stmt + + + + + + +reindex-stmt + + + + + + +release-stmt + + + + + + +rollback-stmt + + + + + + +savepoint-stmt + + + + + + +select-stmt + + + + + + +update-stmt + + + + + + +update-stmt-limited + + + + + + +vacuum-stmt + + + + + + +
+
+ +

This page last modified on 2021-02-02 12:11:09 UTC

+ -- cgit v1.2.3