---
title: "executeUpdateQuery"
description: "Executes an update query using the given ConnectionName (or the default connection it omitted) and returns the number of rows effected."
---

# executeUpdateQuery

> Executes an update query using the given ConnectionName (or the default connection it omitted) and returns the number of rows effected.

:::note Deprecated
This function was deprecated in 8.0.0.
:::

**This function is used by Ignition's Expression language.**

## Description
:::note
This function is only available in Transaction Group Expression Items and Expression Tags.
:::

## Syntax
`executeUpdateQuery(query[, connectionName])`

- Parameters

    - string **query** - The query to execute.

    - string **connectionName** - Optional. The name of the database connection.

- Results
    - int - The number of rows affected.

## Examples
```python title="Code Snippet"
executeUpdateQuery("UPDATE table SET columnName1 = 15.89 WHERE index = 4", "MySQLConnection") //would return a 1 and update the table.
```