Reputation: 577
Basically, I want to insert if a given entry (by its primary key id) doesn't exist, and otherwise update if it does. What might be the best way to do this?
Upvotes: 1
Views: 513
Reputation: 37364
Does sqllite not have REPLACE command ? Or ON CONFLICT REPLACE ?
REPLACE
ON CONFLICT REPLACE