table.upsert()

DOCS • API • Table API

---

Programmatically perform an UPSERT query.

An UPSERT operation is an INSERT operation that automatically converts to an UPDATE operation where the given row data matches an existing record in the table by a unique key. The upsert() API has the exact same signature as that of the insert() API. But UPSERTS are prohibited from having an ON CONFLICT/ON DUPLICATE KEY clause of their own.

See related ➞ UPSERT

Syntax

See ➞ INSERT ➞ Syntax

Usage

See ➞ INSERT ➞ Usage