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. To update a value to a map that includes non-string keys, you must use an array of key-value pairs to update the map column. Otherwise, you can use an array of key-value pairs or a normal map. For examples, Update a map column.
`$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.
`$push`	Appends a single element to a map, list, or set. Use `$push` with `$each` to append multiple elements. For examples, see Append to a list or set column and Append to a map column.
`$each`	Modifies the `$push` operator to append multiple items to a map, list, or set. For examples, see Append to a list or set column and Append to a map column.
`$pullAll`	Removes the specified elements from a list or set, or removes entries that match the specified keys from a map. For examples, see Remove matches from a list or set column and Remove matches from map column.

$set

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

To update a value to a map that includes non-string keys, you must use an array of key-value pairs to update the map column. Otherwise, you can use an array of key-value pairs or a normal map. For examples, Update a map column.

$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.

$push

Appends a single element to a map, list, or set.

Use $push with $each to append multiple elements.

For examples, see Append to a list or set column and Append to a map column.

$each

Modifies the $push operator to append multiple items to a map, list, or set.

For examples, see Append to a list or set column and Append to a map column.

$pullAll

Removes the specified elements from a list or set, or removes entries that match the specified keys from a map.