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/syntax/update-stmt.html | 294 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 294 insertions(+) create mode 100644 www/syntax/update-stmt.html (limited to 'www/syntax/update-stmt.html') diff --git a/www/syntax/update-stmt.html b/www/syntax/update-stmt.html new file mode 100644 index 0000000..d0a375a --- /dev/null +++ b/www/syntax/update-stmt.html @@ -0,0 +1,294 @@ + + + + + +SQLite Syntax: update-stmt + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

update-stmt

+
+
+ + + + +WITH + +RECURSIVE + + + + + +common-table-expression + + + + + + +, + + + + + + + + +UPDATE + + + + + + +OR + + + +ROLLBACK + + + + + +qualified-table-name + +OR + + + +REPLACE + + + + + + +OR + + + +IGNORE + + + + + + +OR + + + +FAIL + + + + + + +OR + + + +ABORT + + + + + + + + + + + +SET + + + +column-name-list + + + += + + + +expr + + + +column-name + + +, + + + + + + + +FROM + + + +table-or-subquery + +, + + + + + + +join-clause + + + + + + + + +WHERE + + + +expr + + + + + + + + + + + +returning-clause + + + +

+ +Used by:   create-trigger-stmt   sql-stmt

+References:   column-name-list   common-table-expression   expr   join-clause   qualified-table-name   returning-clause   table-or-subquery

+See also:   lang_createtrigger.html   lang_update.html +
+ + + -- cgit v1.2.3