SurrealDB Docs Logo

Enter a search query

->upsert()

Creates or updates a record in a table.

Method Syntax
$db->upsert($thing, $data);

Arguments

ArgumentsTypeDescription
$thing required

RecordId. StringRecordId or string

The collection to upsert the record to.

$data required

mixed

The record to upsert.

Example

Example
$id = new RecordId('users', 'tobie'); // Upsert a record to the "users" collection. $response = $db->upsert($id, [ 'firstname' => 'Tobie', 'lastname' => 'Hitchcock', ]);