Word Pronunciation & Dictionary

upsert

Word Rarity Very rare

Frequency: Zipf frequency 0.00 in modern English

Syllables: up-sert
IPA

8

Scrabble Score

6

Letters

2

Syllables

6

Unique Chars

Meaning

verb

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

Transitive verb

noun

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."

Etymology

Blend of update + insert.

Usage

Transitive verb

Inflected Forms

upserts (present, singular) upserting (participle, present) upserted (participle, past) upserted (past) upserts (plural)

Synonyms

merge upsertion

Questions

What does upsert mean?: To insert rows into a database table if they do not already exist, or update them if they do.
Where does upsert come from?: Blend of update + insert.

How to pronounce upsert

Open the pronunciation page — Open the Speakur entry for “upsert”.
Read the phonetic spelling — Read the IPA spelling () so you know which sounds to aim for.
Play the audio — Click Play to hear reference audio for “upsert”.
Repeat and practice — Say “upsert” aloud, matching stress and vowels until it feels natural.