---
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.

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

## Description
:::note
This function is only available in [Transaction Group Expression Items](sql-bridge-transaction-groups/understanding-transaction-groups/expression-items/expression-items.md) and [Expression Tags](tags/creating-memory-expression-and-query-tags/creating-memory-expression-and-query-tags.md).
:::

## 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.
```