- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
- 24.2.7 Descripciones de funciones de sentencias preparadas de la API C
- 24.2.7.1 mysql_stmt_affected_rows()
- 24.2.7.2 mysql_stmt_attr_get()
- 24.2.7.3 mysql_stmt_attr_set()
- 24.2.7.4 mysql_stmt_bind_param()
- 24.2.7.5 mysql_stmt_bind_result()
- 24.2.7.6 mysql_stmt_close()
- 24.2.7.7 mysql_stmt_data_seek()
- 24.2.7.8 mysql_stmt_errno()
- 24.2.7.9 mysql_stmt_error()
- 24.2.7.10 mysql_stmt_execute()
- 24.2.7.11 mysql_stmt_free_result()
- 24.2.7.12 mysql_stmt_insert_id()
- 24.2.7.13 mysql_stmt_fetch()
- 24.2.7.14 mysql_stmt_fetch_column()
- 24.2.7.15 mysql_stmt_field_count()
- 24.2.7.16 mysql_stmt_init()
- 24.2.7.17 mysql_stmt_num_rows()
- 24.2.7.18 mysql_stmt_param_count()
- 24.2.7.19 mysql_stmt_param_metadata()
- 24.2.7.20 mysql_stmt_prepare()
- 24.2.7.21 mysql_stmt_reset()
- 24.2.7.22 mysql_stmt_result_metadata()
- 24.2.7.23 mysql_stmt_row_seek()
- 24.2.7.24 mysql_stmt_row_tell()
- 24.2.7.25 mysql_stmt_send_long_data()
- 24.2.7.26 mysql_stmt_sqlstate()
- 24.2.7.27 mysql_stmt_store_result()
MYSQL_RES *mysql_stmt_result_metadata(MYSQL_STMT
*stmt)
Description
If a statement passed to
mysql_stmt_prepare() is one that produces a
result set, mysql_stmt_result_metadata()
returns the result set metadata in the form of a pointer to a
MYSQL_RES structure that can be used to
process the meta information such as total number of fields
and individual field information. This result set pointer can
be passed as an argument to any of the field-based API
functions that process result set metadata, such as:
mysql_num_fields()mysql_fetch_field()mysql_fetch_field_direct()mysql_fetch_fields()mysql_field_count()mysql_field_seek()mysql_field_tell()mysql_free_result()
The result set structure should be freed when you are done
with it, which you can do by passing it to
mysql_free_result(). This is similar to the
way you free a result set obtained from a call to
mysql_store_result().
The result set returned by
mysql_stmt_result_metadata() contains only
metadata. It does not contain any row results. The rows are
obtained by using the statement handle with
mysql_stmt_fetch().
This function was added in MySQL 4.1.2.
Return Values
A MYSQL_RES result structure.
NULL if no meta information exists for the
prepared query.
Errors
-
CR_OUT_OF_MEMORYOut of memory.
-
CR_UNKNOWN_ERRORAn unknown error occurred.
Example
For the usage of
mysql_stmt_result_metadata(), refer to the
Example from Sección 24.2.7.13, “mysql_stmt_fetch()”.
É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.
