SurrealDB Docs Logo

Enter a search query

->update()

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

Method Syntax
$db->update(thing, data)
Note

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

Arguments

ArgumentsDescription
thing required

The table name or the specific RecordId to update.

data optional

The document / record data to update.

Example usage

// Update all records in a table $people = $db->update('person'); // Update a record with a specific ID $person = $db->update(new RecordId('person', 'tobie'), [ "name" => 'Tobie', "settings" => [ "active" => true, "marketing" => true, ], ]); // The content you are updating the record with might differ from the return type $record = $db->update(new RecordId('person', 'tobie'), [ "name" => 'Tobie', ]);

Translated query

This function will run the following query in the database.

UPDATE $thing CONTENT $data;

On this page

© SurrealDB GitHub Discord Community Cloud Features Releases Install