Data & Databases
Upsert
An insert operation with defined behavior when a specified uniqueness conflict occurs, often updating an existing row instead. The conflict key and update policy are essential. Upsert does not mean ignore every error or accept stale data unconditionally.
Also called: Insert or Update
Reviewed
Sources
Member lesson
The definition and sources are public. The complete practical lesson is for members.