merge | SurrealDB

Merges data into all records in a table, or a specific record, leaving unspecified fields untouched. This is a convenience wrapper that runs UPDATE <thing> MERGE <data_json>;.

Method Syntax

client.merge(thing, data_json, session, txn)

Arguments

Argument	Description
`thing`	The table or specific record to merge into.
`data_json`	The data to merge, as a JSON string.
`session`	An optional session id.
`txn`	An optional transaction id.

Example usage

var resp = client.merge("person:chiru", '{ "age": 31 }')

Translated query

UPDATE $thing MERGE $data_json;