<entry id="2220112" stat="A" corpus="jmdict" type="jmdict">
<ent_corp type="jmdict">jmdict</ent_corp>
<ent_seq>2857309</ent_seq>
<k_ele>
<keb>ＵＰＳＥＲＴ</keb>
</k_ele>
<r_ele>
<reb>アップサート</reb>
</r_ele>
<sense>
<pos>&n;</pos>
<pos>&vs;</pos>
<pos>&vt;</pos>
<field>&comp;</field>
<gloss>upsert</gloss>
<gloss>(database) update or insert</gloss>
</sense>
<info>
<audit time="2023-01-26 03:41:52" stat="A" unap="true">
<upd_name>Nicolas Maia</upd_name>
<upd_detl>SQL keyword.</upd_detl>
<upd_refs>https://consulting-glossary.com/item.php?name=UPSERT
https://ja.wikipedia.org/wiki/UPSERT</upd_refs>
</audit>
<audit time="2023-01-26 03:43:51" stat="A" unap="true">
<upd_name>Nicolas Maia</upd_name>
<upd_refs>https://code-macchiato.com/tips/mysql-upsert</upd_refs>
<upd_diff>@@ -8,0 +9 @@
+&lt;pos&gt;&amp;vs;&lt;/pos&gt;</upd_diff>
</audit>
<audit time="2023-01-26 04:56:54" stat="A">
<upd_uid>jwb</upd_uid>
<upd_name>Jim Breen</upd_name>
<upd_email>...address hidden...</upd_email>
<upd_detl>Not a merge.</upd_detl>
<upd_refs>https://en.m.wiktionary.org/wiki/upsert
An operation that inserts rows into a database table if they do not already exist, or updates them if they do.</upd_refs>
<upd_diff>@@ -12 +12 @@
-&lt;gloss&gt;merge&lt;/gloss&gt;
+&lt;gloss&gt;(database) update or insert&lt;/gloss&gt;</upd_diff>
</audit>
<audit time="2023-01-26 19:52:57" stat="A" unap="true">
<upd_uid>Marcus</upd_uid>
<upd_name>Marcus Richert</upd_name>
<upd_email>...address hidden...</upd_email>
<upd_detl>vi or vt? (I'd assume vt but)</upd_detl>
</audit>
<audit time="2023-01-26 20:32:45" stat="A" unap="true">
<upd_name>Stephen Kraus</upd_name>
<upd_email>...address hidden...</upd_email>
<upd_detl>"UPSERT," "Upsert," or "upsert" are bound to be more common surface forms than アップサート. I guess the all-caps version is okay?</upd_detl>
<upd_refs>A web search for "をUPSERT" has some examples.
インサート is transitive in meikyo and sankoku.

Twitter search for 「"upsert" lang:ja」 pulls up far more results than 「アップサート」</upd_refs>
<upd_diff>@@ -3,0 +4,3 @@
+&lt;k_ele&gt;
+&lt;keb&gt;ＵＰＳＥＲＴ&lt;/keb&gt;
+&lt;/k_ele&gt;
@@ -9,0 +13 @@
+&lt;pos&gt;&amp;vt;&lt;/pos&gt;</upd_diff>
</audit>
<audit time="2023-01-26 20:42:31" stat="A">
<upd_uid>jwb</upd_uid>
<upd_name>Jim Breen</upd_name>
<upd_email>...address hidden...</upd_email>
<upd_detl>I guess caps version is appropriate.</upd_detl>
</audit>
</info>
</entry>