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 db.update('person', {name: "Jaime"}) # Update a record with a specific ID db.update(RecordID('person', 'tobie'), { "name": 'Tobie', "settings": { "active": True, "marketing": True, } })

Translated query

This function will run the following query in the database.

UPDATE $thing CONTENT $data;