ON CONFLICT REPLACE in #sqlite deletes the conflicting row and inserts a new one. ...serpent7776 (53)in DBuzz • 6 months ago ... 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 Posted via D.Buzz #sqlite #sql
More info please. What command platform is used and how does syntax work?
You can see an example usage on the second screenshot.
For more details you can read official documentation.
If you have any more question let me know. https://www.sqlite.org/draft/lang_UPSERT.html https://sqlite.org/lang_conflict.html