(mysql.info) mysql-next-result

Info Catalog

(mysql.info) mysql-more-results

(mysql.info) c-api-functions

(mysql.info) mysql-num-fields

 
 22.2.3.45 `mysql_next_result()'
 ...............................
 
 `int mysql_next_result(MYSQL *mysql)'
 
 *Description*
 
 If more query results exist, `mysql_next_result()' reads the next query
 results and returns the status back to application.
 
 You must call `mysql_free_result()' for the preceding query if it
 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
 query. 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.
 
 See  c-api-multiple-queries.
 
 *Return Values*
 
 *Return Value*         *Description*
 0                      Successful and there are more results
 -1                     Successful and there are no more results
 >0                     An error occurred
 
 *Errors*
 
    * `CR_COMMANDS_OUT_OF_SYNC'
 
      Commands were executed in an improper order. For example if you
      didn't call `mysql_use_result()' for a previous result set.
 
    * `CR_SERVER_GONE_ERROR'
 
      The MySQL server has gone away.
 
    * `CR_SERVER_LOST'
 
      The connection to the server was lost during the query.
 
    * `CR_UNKNOWN_ERROR'
 
      An unknown error occurred.
 

Info Catalog

(mysql.info) mysql-more-results

(mysql.info) c-api-functions

(mysql.info) mysql-num-fields