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

## [Name](#Name)

mysql\_stmt\_fetch - Fetches result set row from a prepared statement

## [Synopsis](#Synopsis)

```
#include <mysql.h>
int mysql_stmt_fetch(MYSQL_STMT * stmt);
    
```

## [Description](#Description)

Fetch the result from a prepared statement into the buffer bound by [mysql\_stmt\_bind\_result()}(mysql\_stmt\_bind\_result).

## [Parameter](#Parameter)

•

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

## [Return value](#Return_value)

Returns 0 for success, MYSQL\_NO\_DATA if the end of the result set has been reached, or MYSQL\_DATA\_TRUNCATION if one or more values are truncated.

## [Notes](#Notes)

•

Note that all columns must be bound by the application before calling mysql\_stmt\_fetch().

•

Data are transferred unbuffered without calling [**mysql\_stmt\_store\_result(3)**](/man/enterprise-packages/mariadb-12.0/mysql_stmt_store_result.3) which can decrease performance (but reduces memory cost).

•

Truncation reporting must be enabled by function [**mysql\_optionsv(3)**](/man/enterprise-packages/mariadb-12.0/mysql_optionsv.3) with option MYSQL\_REPORT\_DATA\_TRUNCATION

## [See Also](#See_Also)

•

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

•

[**mysql\_stmt\_bind\_result(3)**](/man/enterprise-packages/mariadb-12.0/mysql_stmt_bind_result.3)

•

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

Version 3.4

---

Document: mysql_stmt_fetch(3) from mariadb-12.0 12.0.2-r5 (Chainguard OS)