Docs for multiple updates in one query

PierBover · porsager · commit 779d69b7090b · 2022-10-03T22:24:40.000+02:00
Like we chatted on Gitter, I've added this bit of information.

I tried to maintain the style of the code and SQL to the other examples of the docs. Hope the location is ok, I didn't know where to put it.
diff --git a/README.md b/README.md
@@ -232,6 +232,21 @@ sql`
 update users set "name" = $1, "age" = $2 where user_id = $3
 ```
 
+### Multiple updates in one query
+It's possible to create multiple udpates in a single query. It's necessary to use arrays intead of objects to ensure the order of the items so that these correspond with the column names.
+```js
+const users = [
+  [1, 'John', 34],
+  [2, 'Jane', 27],
+]
+
+sql`
+  update users set name = update_data.name, age = update_data.age
+  from (values ${sql(users)}) as update_data (id, name, age)
+  where users.id = update_data.id
+`
+```
+
 ### Dynamic values and `where in`
 Value lists can also be created dynamically, making `where in` queries simple too.
 ```js
