---
name: "mysql_stmt_store_result"
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_store_result"
---

# mysql\_stmt\_store\_result(3)

### Name

mysql\_stmt\_store\_result - Transfers a result set from a prepared statement

### Synopsis

-

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

### Description

You must call mysql\_stmt\_store\_result() for every query that successfully produces a result set only if you want to buffer the complete result set by the client, so that the subsequent **[mysql\_stmt\_fetch(3)](/mysql_stmt_fetch/3.md)** call returns buffered data.

### Parameter

- •

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

### Return value

Returns zero on success, nonzero if an error occurred. ## Notes \* You can detect whether the statement produced a result set by checking the return value of **[mysql\_stmt\_field\_count(3)](/mysql_stmt_field_count/3.md)** function.

### See Also

- •

  **[mysql\_stmt\_field\_count(3)](/mysql_stmt_field_count/3.md)**

- •

  **[mysql\_stmt\_fetch(3)](/mysql_stmt_fetch/3.md)**