N1QL DML

N1QL INSERT, UPDATE, and DELETE statements for modifying documents. RETURNING clause fetches affected documents.

Syntax

couchbase

UPDATE bucket SET field = val WHERE META().id = key RETURNING fields;

Example

couchbase

UPDATE users
SET tier = 'premium', upgradedAt = NOW_STR()
WHERE META().id = 'user:bob'
RETURNING name, tier;

DELETE FROM users WHERE META().id = 'user:bob';