---
title: Update data | Tiger Data Docs
description: Update single and multiple rows in a hypertable in your TimescaleDB database with SQL
---

Point fixes and time-bounded corrections both use [`UPDATE`](https://www.postgresql.org/docs/current/sql-update.html) against a hypertable, just like a regular table.

Try this with your AI agent

In Tiger Cloud, [set up Tiger MCP](/get-started/quickstart/mcp-cli/index.md) and ask your AI agent to do this for you. See [example prompts](/build/tiger-cli-mcp/common-tasks/index.md) to get started, and [best practices](/build/tiger-cli-mcp/agent-best-practices/index.md) to keep it safe.

This works the same whether the chunk is in the rowstore or the columnstore. You don't need to decompress a chunk before updating it: TimescaleDB decompresses only the rows your statement touches, not the whole chunk.

## Update a single row

Update a single row with the syntax `UPDATE ... SET ... WHERE`. For example, to update a row in the `conditions` hypertable with new `temperature` and `humidity` values, run the following. The `WHERE` clause specifies the row to be updated.

```
UPDATE conditions
  SET temperature = 70.2, humidity = 50.0
  WHERE time = '2017-07-28 11:42:42.846621+00'
    AND location = 'office';
```

## Update multiple rows at once

You can also update multiple rows at once, by using a `WHERE` clause that filters for more than one row. For example, run the following to update all `temperature` values within the given 10-minute span:

```
UPDATE conditions
  SET temperature = temperature + 0.1
  WHERE time >= '2017-07-28 11:40'
    AND time < '2017-07-28 11:50';
```