sqlite3 insert or replace

test.sql

-- insert or replace sqlite 3.x

create table config( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, key text, value text );
insert into config values (1, "fg", "#ff00ff" );
insert or replace into config(id, key, value) values ((select id from config where key = "bg"), "bg", "0x00ff00");
SELECT * FROM config;

$ sqlite3 < test.sql
SQLite version 3.34.0 2020-12-01 16:14:00
1|fg|#ff00ff
2|bg|0x00ff00