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?

a1ex07 · Accepted Answer · 2010-09-16 22:50:53Z

1

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

answered Sep 16, 2010 at 22:50

a1ex07

37.4k12 gold badges94 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pascal Over a year ago

Note that REPLACE resets any fields you're not explicitly setting in your query. Sadly there is no ON CONFLICT UPDATE...

Collectives™ on Stack Overflow

SQLite, SQL: Using UPDATE or INSERT accordingly

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related