mysql_more_results

mysql_more_results indicates whether additional result sets remain from a previous multi-statement query, returning 1 if more results are available.

Syntax

my_bool mysql_more_results(MYSQL * mysql);

Parameter

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Description

Indicates if one or more result sets are available from a previous call to mysql_real_query().

Return Value

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

• The function mysql_set_server_option() 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.

See Also

• mysql_real_query()

• mysql_use_result()

• mysql_store_result()

• mysql_next_result()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}