SQLite Forum

What is the recommended way to update multiple columns from a single select?
Take a look into this:


section 2.2. UPDATE FROM

I have tested (on last version) before I send it but you must have at least
SQLite version 3.33.0 (2020-08-14).

If you got error then you have older version.