- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
- 24.2.3 Descripción de funciones de la API C
- 24.2.3.1 mysql_affected_rows()
- 24.2.3.2 mysql_change_user()
- 24.2.3.3 mysql_character_set_name()
- 24.2.3.4 mysql_close()
- 24.2.3.5 mysql_connect()
- 24.2.3.6 mysql_create_db()
- 24.2.3.7 mysql_data_seek()
- 24.2.3.8 mysql_debug()
- 24.2.3.9 mysql_drop_db()
- 24.2.3.10 mysql_dump_debug_info()
- 24.2.3.11 mysql_eof()
- 24.2.3.12 mysql_errno()
- 24.2.3.13 mysql_error()
- 24.2.3.14 mysql_escape_string()
- 24.2.3.15 mysql_fetch_field()
- 24.2.3.16 mysql_fetch_fields()
- 24.2.3.17 mysql_fetch_field_direct()
- 24.2.3.18 mysql_fetch_lengths()
- 24.2.3.19 mysql_fetch_row()
- 24.2.3.20 mysql_field_count()
- 24.2.3.21 mysql_field_seek()
- 24.2.3.22 mysql_field_tell()
- 24.2.3.23 mysql_free_result()
- 24.2.3.24 mysql_get_character_set_info()
- 24.2.3.25 mysql_get_client_info()
- 24.2.3.26 mysql_get_client_version()
- 24.2.3.27 mysql_get_host_info()
- 24.2.3.28 mysql_get_proto_info()
- 24.2.3.29 mysql_get_server_info()
- 24.2.3.30 mysql_get_server_version()
- 24.2.3.31 mysql_hex_string()
- 24.2.3.32 mysql_info()
- 24.2.3.33 mysql_init()
- 24.2.3.34 mysql_insert_id()
- 24.2.3.35 mysql_kill()
- 24.2.3.36 mysql_library_init()
- 24.2.3.37 mysql_library_end()
- 24.2.3.38 mysql_list_dbs()
- 24.2.3.39 mysql_list_fields()
- 24.2.3.40 mysql_list_processes()
- 24.2.3.41 mysql_list_tables()
- 24.2.3.42 mysql_num_fields()
- 24.2.3.43 mysql_num_rows()
- 24.2.3.44 mysql_options()
- 24.2.3.45 mysql_ping()
- 24.2.3.46 mysql_query()
- 24.2.3.47 mysql_real_connect()
- 24.2.3.48 mysql_real_escape_string()
- 24.2.3.49 mysql_real_query()
- 24.2.3.50 mysql_reload()
- 24.2.3.51 mysql_row_seek()
- 24.2.3.52 mysql_row_tell()
- 24.2.3.53 mysql_select_db()
- 24.2.3.54 mysql_set_character_set()
- 24.2.3.55 mysql_set_server_option()
- 24.2.3.56 mysql_shutdown()
- 24.2.3.57 mysql_sqlstate()
- 24.2.3.58 mysql_ssl_set()
- 24.2.3.59 mysql_stat()
- 24.2.3.60 mysql_store_result()
- 24.2.3.61 mysql_thread_id()
- 24.2.3.62 mysql_use_result()
- 24.2.3.63 mysql_warning_count()
- 24.2.3.64 mysql_commit()
- 24.2.3.65 mysql_rollback()
- 24.2.3.66 mysql_autocommit()
- 24.2.3.67 mysql_more_results()
- 24.2.3.68 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 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_SYNCCommands were executed in an improper order. For example if you didn't call
mysql_use_result()for a previous result set. -
CR_SERVER_GONE_ERRORThe MySQL server has gone away.
-
CR_SERVER_LOSTThe connection to the server was lost during the query.
-
CR_UNKNOWN_ERRORAn 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.
