upsert

Blend of update +‎ insert.

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

1. (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)

1. (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.

• purset, puters, erupts, purest, 'puters, rest up, uprest