---
name: "mysql_stmt_reset"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_stmt_reset"
---

# mysql\_stmt\_reset(3)

### Name

mysql\_stmt\_reset - Resets a prepared statement

### Synopsis

-

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

### Description

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

### Parameter

- •

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

### Return value

Returns zero on success, 1 if an error occurred.

### 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)](/mysql_stmt_prepare/3.md)**.

### See Also

- •

  **[mysql\_stmt\_close(3)](/mysql_stmt_close/3.md)**

- •

  **[mysql\_stmt\_prepare(3)](/mysql_stmt_prepare/3.md)**

- •

  **[mysql\_stmt\_execute(3)](/mysql_stmt_execute/3.md)**