---
name: "mysql_more_results"
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_more_results"
---

# mysql\_more\_results(3)

### Name

mysql\_more\_results - indicates if one or more results are available

### Synopsis

-

  ```
  #include <mysql.h>
  my_bool mysql_more_results(MYSQL * mysql);
  ```

### Description

Indicates if one or more result sets are available from a previous call to **[mysql\_real\_query(3)](/mysql_real_query/3.md)**.

### Parameter

- •

  `mysql` - a connection identifier, which was previously allocated by **[mysql\_init(3)](/mysql_init/3.md)** and connected by **[mysql\_real\_connect(3)](/mysql_real_connect/3.md)**.

### Notes

- •

  The function **[mysql\_set\_server\_option(3)](/mysql_set_server_option/3.md)** enables or disables multi statement support.

- •

  Multiple result sets can be obtained either by calling a stored procedure or by executing concatenated statements, e.g. `SELECT a FROM t1;SELECT b, c FROM t2`.

### Return value

Returns 1 if more result sets are available, otherwise zero.

### See also

- •

  **[mysql\_real\_query(3)](/mysql_real_query/3.md)**

- •

  **[mysql\_use\_result(3)](/mysql_use_result/3.md)**

- •

  **[mysql\_store\_result(3)](/mysql_store_result/3.md)**

- •

  **[mysql\_next\_result(3)](/mysql_next_result/3.md)**

- •

  **[mysql\_set\_server\_option(3)](/mysql_set_server_option/3.md)**