SQLite, SQL: Using UPDATE or INSERT accordingly

Question

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?

score 1 · Accepted Answer · answered Sep 16 '10 at 22:50

1

Does sqllite not have REPLACE command ? Or ON CONFLICT REPLACE ?

answered Sep 16 '10 at 22:50

a1ex07

36,826
12
90
103

Note that `REPLACE` resets any fields you're not explicitly setting in your query. Sadly there is no `ON CONFLICT UPDATE`... – Pascal Nov 27 '10 at 11:22

SQLite, SQL: Using UPDATE or INSERT accordingly

1 Answers1