int mysql_next_result(MYSQL *mysql)

Description

This function is used when you execute multiple statements specified as a single statement string.

If more statement results exist, mysql_next_result() reads the next statement result and returns the status back to the application.

Before calling mysql_next_result(), you must call mysql_free_result() for the preceding statement if it is a query that returned a result set.

After calling mysql_next_result() the state of the connection is as if you had called mysql_real_query() or mysql_query() for the next statement. This means that you can call mysql_store_result(), mysql_warning_count(), mysql_affected_rows(), and so forth.

If mysql_next_result() returns an error, no other statements are executed and there are no more results to fetch.

For an example that shows how to use mysql_next_result(), see Section 17.2.9, “C API Handling of Multiple Statement Execution”.

This function was added in MySQL 4.1.0.

Return Values

Errors