Update operators for tables

Use update operators to update rows in a table. You can use update operators on all supported types.

For examples, see the references for commands that use these operators, such as Update a row.

Name Purpose

Name	Purpose
`$set`	Sets a given column’s value to the specified value. For examples, see Update multiple columns.
`$unset`	Sets a given column’s value to `null` or the equivalent empty form, such as `[]` or `{}` for map, list, and set types. For examples, see Update multiple columns and Unset columns.

$set

Sets a given column’s value to the specified value. For examples, see Update multiple columns.

$unset

Sets a given column’s value to null or the equivalent empty form, such as [] or {} for map, list, and set types.

$rename isn’t supported. Instead, use alterTable to add and drop columns.

Give Feedback