- 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()
int mysql_stmt_attr_set(MYSQL_STMT *stmt, enum
enum_stmt_attr_type option, const void *arg)
Description
Can be used to set affect behavior for a statement. This function may be called multiple times to set several options.
The option argument is the option that you
want to set; the arg argument is the value
for the option. If the option is an integer, then
arg should point to the value of the
integer.
Possible option values:
| Option | Argument Type | Function |
STMT_ATTR_UPDATE_MAX_LENGTH |
my_bool * |
If set to 1: Update metadata
MYSQL_FIELD->max_length in
mysql_stmt_store_result(). |
STMT_ATTR_CURSOR_TYPE |
unsigned long * |
Type of cursor to open for statement when
mysql_stmt_execute() is invoked.
*arg can be
CURSOR_TYPE_NO_CURSOR (the default)
or CURSOR_TYPE_READ_ONLY. |
STMT_ATTR_PREFETCH_ROWS |
unsigned long * |
Number of rows to fetch from server at a time when using a cursor.
*arg can be in the range from 1 to
the maximum value of unsigned long.
The default is 1. |
If you use the STMT_ATTR_CURSOR_TYPE option
with CURSOR_TYPE_READ_ONLY, a cursor is
opened for the statement when you invoke
mysql_stmt_execute(). If there is already
an open cursor from a previous
mysql_stmt_execute() call, it closes the
cursor before opening a new one.
mysql_stmt_reset() also closes any open
cursor before preparing the statement for re-execution.
mysql_stmt_free_result() closes any open
cursor.
This function was added in MySQL 4.1.2. The
STMT_ATTR_CURSOR_TYPE option was added in
MySQL 5.0.2. The STMT_ATTR_PREFETCH_ROWS
option was added in MySQL 5.0.6.
Return Values
0 if okay. Non-zero if
option is unknown.
Errors
None.
É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.
