- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 17.2.7 C API Prepared Statement Function Descriptions
- 17.2.7.1 mysql_stmt_affected_rows()
- 17.2.7.2 mysql_stmt_attr_get()
- 17.2.7.3 mysql_stmt_attr_set()
- 17.2.7.4 mysql_stmt_bind_param()
- 17.2.7.5 mysql_stmt_bind_result()
- 17.2.7.6 mysql_stmt_close()
- 17.2.7.7 mysql_stmt_data_seek()
- 17.2.7.8 mysql_stmt_errno()
- 17.2.7.9 mysql_stmt_error()
- 17.2.7.10 mysql_stmt_execute()
- 17.2.7.11 mysql_stmt_fetch()
- 17.2.7.12 mysql_stmt_fetch_column()
- 17.2.7.13 mysql_stmt_field_count()
- 17.2.7.14 mysql_stmt_free_result()
- 17.2.7.15 mysql_stmt_init()
- 17.2.7.16 mysql_stmt_insert_id()
- 17.2.7.17 mysql_stmt_num_rows()
- 17.2.7.18 mysql_stmt_param_count()
- 17.2.7.19 mysql_stmt_param_metadata()
- 17.2.7.20 mysql_stmt_prepare()
- 17.2.7.21 mysql_stmt_reset()
- 17.2.7.22 mysql_stmt_result_metadata()
- 17.2.7.23 mysql_stmt_row_seek()
- 17.2.7.24 mysql_stmt_row_tell()
- 17.2.7.25 mysql_stmt_send_long_data()
- 17.2.7.26 mysql_stmt_sqlstate()
- 17.2.7.27 mysql_stmt_store_result()
17.2.7.12. mysql_stmt_fetch_column()
int mysql_stmt_fetch_column(MYSQL_STMT *stmt,
MYSQL_BIND *bind, unsigned int column, unsigned long
offset)
Description
Fetch one column from the current result set row.
bind provides the buffer where data should be
placed. It should be set up the same way as for
mysql_stmt_bind_result().
column indicates which column to fetch. The
first column is numbered 0. offset is the
offset within the data value at which to begin retrieving data.
This can be used for fetching the data value in pieces. The
beginning of the value is offset 0.
This function was added in MySQL 4.1.2.
Return Values
Zero if the value was fetched successfully. Non-zero if an error occurred.
Errors
-
CR_INVALID_PARAMETER_NOInvalid column number.
-
CR_NO_DATAThe end of the result set has already been reached.
User Comments
This is a bit missleading: "bind provides the buffer where data should be placed. It should be set up the same way as for mysql_stmt_bind_result()."
The 'bind' argument expects a MYSQL_BIND structure setup for the target field, not the array of MYSQL_BIND structures used in 'mysql_stmt_bind_result()'.
Add your own comment.