sqlite

sqlite.sql

-- This will replace the other fields to default value
INSERT OR REPLACE INTO book(id, name) VALUES(1001, 'Programming');

-- INSERT OR UPDATE (Method 1)
INSERT OR IGNORE INTO book(id) VALUES(1001);
UPDATE book SET name = 'Programming';

-- INSERT OR UPDATE (Method 2)
INSERT OR REPLACE INTO book (id, name) 
VALUES (1001, 'Programming',
    (SELECT type FROM book WHERE id = 1001),
    (SELECT price FROM book WHERE id = 1001),
)