upsert

Definition

To insert rows into a database table if they do not already exist, or update them if they do.

Etymology

Blend of update + insert.

Example Sentences

• "Each entity event is upserted into the key/value table, such that the most recently read event for a given key is represented."