mysql_stmt_next_result

mysql_stmt_next_result advances to the next result set when a prepared statement returns multiple results, enabling traversal of multi-statement query output.

Syntax

int mysql_stmt_next_result(MYSQL_STMT * stmt);

Parameter

• stmt - a statement handle, which was previously allocated by mysql_stmt_init().

Description

Prepares next result set from a previous call to mysql_stmt_execute() which can be retrieved by mysql_stmt_store_result().

Return Value

Returns zero on success, -1 if there are no more result sets, and a positive value if an error occurred.

• The function mysql_stmt_store_result() indicates if further result sets are available.

• If the execution of a stored procedure produced multiple result sets the return value of mysql_stmt_errno()/mysql_stmt_error() might change and there will be no result set available.

See Also

• mysql_stmt_execute()

• mysql_stmt_store_result()

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