upsertとは 意味・読み方・使い方

動詞

upsert (三人称単数 現在形 upserts, 現在分詞 upserting, 過去形および過去分詞形 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 (複数形 upserts)

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

   Synonym: (SQL standard) merge

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

アナグラム

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