table.upsert()

DOCS • API • Table API

---

Programmatically perform an UPSERT query.

See related ➞ UPSERT

Syntax

See ➞ INSERT ➞ Syntax

Usage

See ➞ INSERT ➞ Usage

An UPSERT operation is an INSERT operation that automatically converts to an UPDATE operation where provided entry matches an existing record by a unique key. API usage is same as insert(). But UPSERTS are prohibited from having an explicit "ON CONFLICT"/"ON UPDATE" clause.