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

# LyznDB Update

> Update data in your personal database

# LyznDB Update

Update data in your personal database

## Properties

| Property   | Value         |
| ---------- | ------------- |
| **Type**   | lyzndb-update |
| **Family** | Actions       |
| **Group**  | Database      |

## Parameters

| Name        | Label            | Type   | Description                            | Required |
| ----------- | ---------------- | ------ | -------------------------------------- | -------- |
| table       | Table Name       | String | Name of the table to update            | Yes      |
| data        | Data             | JSON   | Object with columns to update          | Yes      |
| where       | WHERE Clause     | String | WHERE condition (use ? for parameters) | Yes      |
| whereParams | WHERE Parameters | JSON   | Array of parameters for WHERE clause   | No       |

## Outputs

| Name        | Label       | Type    | Description              |
| ----------- | ----------- | ------- | ------------------------ |
| rowsUpdated | rowsUpdated | number  | Number of rows updated   |
| success     | success     | boolean | Whether update succeeded |