- 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()
my_bool mysql_stmt_bind_param(MYSQL_STMT *stmt,
MYSQL_BIND *bind)
Description
mysql_stmt_bind_param() is used to bind
data for the parameter markers in the SQL statement that was
passed to mysql_stmt_prepare(). It uses
MYSQL_BIND structures to supply the data.
bind is the address of an array of
MYSQL_BIND structures. The client library
expects the array to contain an element for each
'?' parameter marker that is present in the
query.
Suppose that you prepare the following statement:
INSERT INTO mytbl VALUES(?,?,?)
When you bind the parameters, the array of
MYSQL_BIND structures must contain three
elements, and can be declared like this:
MYSQL_BIND bind[3];
The members of each MYSQL_BIND element that
should be set are described in
Sección 24.2.5, “Tipos de datos de sentencias preparadas de la API C”.
This function was added in MySQL 4.1.2.
Return Values
Zero if the bind was successful. Non-zero if an error occurred.
Errors
-
CR_INVALID_BUFFER_USEIndicates if the bind is to supply the long data in chunks and if the buffer type is non string or binary.
-
CR_UNSUPPORTED_PARAM_TYPEThe conversion is not supported. Possibly the
buffer_typevalue is illegal or is not one of the supported types. -
CR_OUT_OF_MEMORYOut of memory.
-
CR_UNKNOWN_ERRORAn unknown error occurred.
Example
For the usage of mysql_stmt_bind_param(),
refer to the Example from
Sección 24.2.7.10, “mysql_stmt_execute()”.
É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.
