int mysql_stmt_next_result(MYSQL_STMT *mysql)
This function is used when you use prepared
CALL statements to execute
stored procedures, which can return multiple result sets. Use
a loop that calls
determine whether there are more results. If a procedure has
their values will be returned as a single-row result set
following any other result sets. The values will appear in the
order in which they are declared in the procedure parameter
For information about the effect of unhandled conditions on procedure parameters, see Section 18.104.22.168, “Condition Handling and OUT or INOUT Parameters”.
state of the connection is as if you had called
means that you can call
and so forth.
It is also possible to test whether there are more results by
However, this function does not change the connection state,
so if it returns true, you must still call
advance to the next result.
For an example that shows how to use
Section 23.7.17, “C API Prepared CALL Statement Support”.
|0||Successful and there are more results|
|-1||Successful and there are no more results|
|>0||An error occurred|