mysql_next_result

mysql_next_result advances to the next result set from a multi-statement query, making it available for retrieval via mysql_store_result or mysql_use_result.

Syntax

int mysql_next_result(MYSQL * mysql);

Parameter

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

Description

Prepares next result set from a previous call to mysql_real_query() which can be retrieved by mysql_store_result() or mysql_use_result().

Return Value

Returns zero on success, nonzero if an error occurred.

If a multi query contains errors the return value of mysql_errno/error() might change and there will be no result set available.

See Also

• mysql_real_query()

• mysql_store_result()

• mysql_use_result()

• mysql_more_results()

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