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

## [Name](#Name)

mysql\_stmt\_close - Closes a prepared statement

## [Synopsis](#Synopsis)

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

## [Description](#Description)

Closes a prepared statement and deallocates the statement handle. If the current statement has pending or unread results, this function cancels them so that the next query can be executed.

## [Parameter](#Parameter)

•

stmt - a statement handle, which was previously allocated by [**mysql\_stmt\_init(3)**](/man/os/mariadb-13.1/mysql_stmt_init.3).

## [Return value](#Return_value)

Returns zero on success, nonzero on error (when communicating with the server). The statement is deallocated, regardless of the error.

## [Notes](#Notes)

•

If you want to reuse the statement handle with a different SQL command, use [**mysql\_stmt\_reset(3)**](/man/os/mariadb-13.1/mysql_stmt_reset.3).

## [See Also](#See_Also)

•

[**mysql\_stmt\_init(3)**](/man/os/mariadb-13.1/mysql_stmt_init.3)

•

[**mysql\_stmt\_reset(3)**](/man/os/mariadb-13.1/mysql_stmt_reset.3)

Version 3.4

---

Document: mysql_stmt_close(3) from mariadb-13.1 13.1.1-r1 (Chainguard OS)