---
title: Update a Table
sidebarTitle: 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
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>
