I didn't realise `UPDATE FROM` was so recent for Sqlite! The version on my workstation is indeed older:
``` $ cat /etc/issue.net Linux Mint 20.1 Ulyssa $ apt show libsqlite3-0 | grep Version Version: 3.31.1-4ubuntu0.2 $ sqlite3 --version 3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1 ```
And:
``` $ sqlite3 mixxxdb.sqlite "select * from settings where name = 'mixxx.schema.version';" mixxx.schema.version|38|0|0 ```
I didn't realise `UPDATE FROM` was so recent for Sqlite! The version on my workstation is indeed older:
``` 8521b342961df8f 5f68c7388fa1173 45eeb516eaa837b alt1
$ cat /etc/issue.net
Linux Mint 20.1 Ulyssa
$ apt show libsqlite3-0 | grep Version
Version: 3.31.1-4ubuntu0.2
$ sqlite3 --version
3.31.1 2020-01-27 19:55:54 3bfa9cc97da1059
```
And:
``` schema. version' ;" version| 38|0|0
$ sqlite3 mixxxdb.sqlite "select * from settings where name = 'mixxx.
mixxx.schema.
```