`->merge()`

Modifies all records in a table, or a specific record, in the database.

Method Syntax

$db->merge($thing, $data)

Note

This function merges the current document / record data with the specified data.

Arguments

Arguments	Type	Description
`thing`	`string`, `RecordId` or `StringRecordId`	The table name or the specific `RecordId` to merge.
`data`	`mixed`	The document / record data to merge.

Example usage

// Update all records in a table
$people = $db->merge('person', [
	"updated_at" => new Date(),
]);

// Update a record with a specific ID
$person = $db->merge(new RecordId('person', 'tobie'), [
	"updated_at" => new Date(),
	"settings" => [
		"active" => true,
	],
]);

// The content you are merging the record with might differ from the return type
$record = $db->merge(new RecordId('person', 'tobie'), [
	"name" => 'Tobie',
]);

Translated query

This function will run the following query in the database.

UPDATE $thing MERGE $data;