Top "Upsert" questions

For issues relating to performing upsert (combination update/insert) operations.

Mongodb upsert only update selected fields, but insert all

I am trying to use upsert in MongoDB to update a single field in a document if found OR insert …

mongodb upsert
Upsert (update or insert) in Sybase ASE?

I'm writing an application to move data from Oracle to Sybase and need to perform update / insert operations. In Oracle, …

sql sap-ase upsert
Bulk Upsert with MongoDB Java 3.0 Driver

In the earlier versions of MongoDB Java drivers , to run a query and do unordered bulk upsert on the result …

java mongodb upsert mongo-java-driver
Bulk update/upsert in MongoDB?

Is it possible to do bulk update/upsert (not insert) in MongoDB? If yes, please point me to any docs …

mongodb batch-file bulk upsert nosql
How to mimic upsert behavior using Hibernate?

I'm writing an application that sync's entities from a third party datasource into our own schema, with a transformation/mapping …

java hibernate orm upsert
Atomic UPSERT in SQL Server 2005

What is the correct pattern for doing an atomic "UPSERT" (UPDATE where exists, INSERT otherwise) in SQL Server 2005? I see …

sql-server sql-server-2005 atomic upsert
insert or update(upsert) in loopback application

I developed an API using Loopback framework, in that i have to insert or update to a table. My table …

node.js loopbackjs upsert
MongoDB: update dictionary in document

I have a MongoDB document that saves occurrences of some things in a dictionary: { "id" : 1, "occurrences" : { "1" : 1, "2" : 5, "17" : 1, "35" : 4 } } I now want to …

mongodb dictionary upsert
Oracle PLS-00103 error. How do you check for an existing record and do update or insert based on that condition?

I need to check if a record exists in the table or not from a SELECT statement. If the record …

sql oracle plsql upsert ora-00900
Postgres on conflict do update on composite primary keys

I have a table where a user answers to a question. The rules are that the user can answer to …

sql postgresql upsert