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

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 +
+ + + -- cgit v1.2.3