Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Merge (SQL)
open-in-new
<p>A <a href="/facts/Relational_database_management_system/pEKGmJLy">relational database management system</a> uses <a href="/facts/SQL/UjQLJcYm">SQL</a> MERGE (also called <i>upsert</i>) statements to <a href="/facts/Insert_(SQL)/UvooNUmg">INSERT</a> new records or <a href="/facts/Update_(SQL)/IQz2IKpz">UPDATE</a> or <a href="/facts/Delete_(SQL)/gyapLh6T">DELETE</a> existing records depending on whether <a href="/facts/Condition_(SQL)/0g2y5tG2">condition</a> matches. It was officially introduced in the <a href="/facts/SQL:2003/V9GLzgLQ">SQL:2003</a> standard, and expanded in the <a href="/facts/SQL:2008/AvdA9y8s">SQL:2008</a> standard. </p>