upsert

upsert: 1. verb

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

2. noun

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

Игры ⚽ Поможем написать реферат

Upsert — The SQL like UPSERT statement inserts a record to a table in a database if the record does not exist; if the record already exists, an update operation is performed. This is not a standard SQL statement, but it is frequently used to abbreviate… … Wikipedia
TPump — is a Teradata utility.Teradata TPump – Continuous Data LoadingTeradata TPump is a highly parallel utility designed to continuously move data from data sources into Teradata tables without locking the affected table. TPump provides near real time… … Wikipedia
SQL — This article is about the database language. For the airport with IATA code SQL, see San Carlos Airport. SQL Paradigm(s) Multi paradigm Appeared in 1974 Designed by Donald D. Chamberlin Raymond F. Boyce Developer … Wikipedia
Merge (SQL) — A relational database management system uses SQL MERGE (upsert) statements to INSERT new records or UPDATE existing records depending on whether or not a condition matches. It was officially introduced in the SQL:2008 standard. Contents 1 Usage 2 … Wikipedia

Academic Dictionaries and Encyclopedias