SQLite Forum

What is the recommended way to update multiple columns from a single select?
Thank you for the reply

Are we sure option 1 is working?

It gives me the following errors:

[2021-05-13 15:27:44] Unsafe query: 'Update' statement without 'where' updates all table rows at once

[2021-05-13 15:28:08] [1] [SQLITE_ERROR] SQL error or missing database (no such column: src.val_a)