ON CONFLICT REPLACE in #sqlite deletes the conflicting row and inserts a new one. ...
Words
31
Reading
1 min
Listen
Play
2y
... This means that the primary key will be changed unless you specify it directly. Use INSERT ... ON CONFLICT DO UPDATE to keep the old id.
#sql