Upsert

Quick meaning: Upsert is a verb meaning (databases, transitive) To insert rows into a database table if they do not already exist, or update them if they do.

Meaning

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

More Meanings

1. (databases) An operation that inserts rows into a database table if they do not already exist, or updates them if they do.

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.

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.

Word Forms

• upserts
• upserting
• upserted

Synonyms for upsert

Depending on context, synonyms include merge, upsertion.

Related Words

Related dictionary entries include reinsert, post-increment, reparent, crosswalk, transplace, upgrade.

Related Dictionary Tools