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 Sección 24.2.9, “Tratamiento por parte de la API C de la ejecución de múltiples consultas”.
This function was added in MySQL 4.1.0.
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.
Ésta es una traducción del manual de referencia de MySQL, que puede encontrarse en dev.mysql.com. El manual de referencia original de MySQL está escrito en inglés, y esta traducción no necesariamente está tan actualizada como la versión original. Para cualquier sugerencia sobre la traducción y para señalar errores de cualquier tipo, no dude en dirigirse a mysql-es@vespito.com.