table.upsert()

DOCS • API • Table API

---

Programmatically perform an UPSERT query.

See also ➞ 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 as upsert(). But upserts are prohibited from having an explicit "ON CONFLICT"/"ON UPDATE" clause.