> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Update a Table

## Description

The `update()` function is executed on a table from a data source connected to MindsDB. It updates a table on specified columns.

## Syntax

Here is the syntax:

```sql theme={null}
my_table.update(table_used_to_update, on=['column1', 'column2', ...])
```

<Info>
  Check out the [SQL syntax](/sql/api/update) to better understand how the `update()` function works.
</Info>