mysql\_stmt\_reset(3) MariaDB Connector/C mysql\_stmt\_reset(3)

## [Name](#Name)

mysql\_stmt\_reset - Resets a prepared statement

## [Synopsis](#Synopsis)

```
#include <mysql.h>
my_bool mysql_stmt_reset(MYSQL_STMT * stmt);
    
```

## [Description](#Description)

Resets a prepared statement on client and server to state after prepare.

## [Parameter](#Parameter)

•

stmt - a statement handle, which was previously allocated by [**mysql\_stmt\_init(3)**](/man/enterprise-packages/mariadb-10.6/mysql_stmt_init.3). Returns zero on success, nonzero if an error occurred.

## [Return value](#Return_value)

Returns zero on success, 1 if an error occurred.

## [Notes](#Notes)

•

mysql\_stmt\_reset() resets the statement on the server, unbuffered result sets and errors. Bindings and stored result sets will not be cleared. The latter one will be cleared when re-executing or closing the prepared statement.

•

To reprepare a prepared statement with another SQL statement use [**mysql\_stmt\_prepare(3)**](/man/enterprise-packages/mariadb-10.6/mysql_stmt_prepare.3).

## [See Also](#See_Also)

•

[**mysql\_stmt\_close(3)**](/man/enterprise-packages/mariadb-10.6/mysql_stmt_close.3)

•

[**mysql\_stmt\_prepare(3)**](/man/enterprise-packages/mariadb-10.6/mysql_stmt_prepare.3)

•

[**mysql\_stmt\_execute(3)**](/man/enterprise-packages/mariadb-10.6/mysql_stmt_execute.3)

Version 3.3

---

Document: mysql_stmt_reset(3) from mariadb-10.6 10.6.28-r5 (Chainguard OS)
Source: https://github.com/MariaDB/server.git