upsert

English

English Wikipedia has an article on:

merge (SQL)

upsert (third-person singular simple present upserts, present participle upserting, simple past and past participle upserted)

(databases, transitive) To insert rows into a database table if they do not already exist, or update them if they do.
- 2020, Adam Bellemare, Building Event-Driven Microservices, O'Reilly, →ISBN, page 25:
  Each entity event is upserted into the key/value table, such that the most recently read event for a given key is represented.

upsert (plural upserts)

(databases) An operation that inserts rows into a database table if they do not already exist, or updates them if they do.
Synonyms: (SQL standard) merge, upsertion
- 2013, David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins, The Definitive Guide to MongoDB, Apress, →ISBN, page 66:
  The upsert option lets you specify whether the update should be an upsert—that is, it tells MongoDB to update the record if it exists, and create it if it doesn't.