A better you
with better words.

Find the right word.
Understand it completely.

upsert

/ˈʌpsərt/ /ʌpˈsɜːt/
  1. 1 upsert

Definition (English)

To insert a record into a database if it doesn't exist, or update it if it does.

Example Sentences

  1. The system will upsert the new user data.
    Sistem yeni kullanıcı verilerini upsert edecek.
  2. Use the upsert command to add or change records.
    Kayıt eklemek veya değiştirmek için upsert komutunu kullanın.

Verb Forms Regular

Base upsert
/ˈʌpsərt/
Past upserted
/ˈʌpsərtɪd/
Participle upserted
/ˈʌpsərtɪd/
Spelling rule

Add ‑edupsert → upserted

Fiilin sonuna -ed eklenir.

Same rule: work → worked · want → wanted · help → helped

Pronunciation of -ed
/t/worked /d/played /ɪd/wanted

Fiil /t/ sesiyle bittiği için -ed ayrı bir hece olur ve /ɪd/ okunur. upserted /ˈʌpsərtɪd/

Synonyms

insert or updatemerge

Collocations

upsert operationupsert commandupsert query