- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 17.6.7 C API Prepared Statement Function Descriptions
- 17.6.7.1 mysql_stmt_affected_rows()
- 17.6.7.2 mysql_stmt_attr_get()
- 17.6.7.3 mysql_stmt_attr_set()
- 17.6.7.4 mysql_stmt_bind_param()
- 17.6.7.5 mysql_stmt_bind_result()
- 17.6.7.6 mysql_stmt_close()
- 17.6.7.7 mysql_stmt_data_seek()
- 17.6.7.8 mysql_stmt_errno()
- 17.6.7.9 mysql_stmt_error()
- 17.6.7.10 mysql_stmt_execute()
- 17.6.7.11 mysql_stmt_fetch()
- 17.6.7.12 mysql_stmt_fetch_column()
- 17.6.7.13 mysql_stmt_field_count()
- 17.6.7.14 mysql_stmt_free_result()
- 17.6.7.15 mysql_stmt_init()
- 17.6.7.16 mysql_stmt_insert_id()
- 17.6.7.17 mysql_stmt_num_rows()
- 17.6.7.18 mysql_stmt_param_count()
- 17.6.7.19 mysql_stmt_param_metadata()
- 17.6.7.20 mysql_stmt_prepare()
- 17.6.7.21 mysql_stmt_reset()
- 17.6.7.22 mysql_stmt_result_metadata()
- 17.6.7.23 mysql_stmt_row_seek()
- 17.6.7.24 mysql_stmt_row_tell()
- 17.6.7.25 mysql_stmt_send_long_data()
- 17.6.7.26 mysql_stmt_sqlstate()
- 17.6.7.27 mysql_stmt_store_result()
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. Nonzero if an error occurred.
Errors
-
Invalid column number.
-
The 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()'.
Please note: even if you only use this function to fetch your fields, you still have to bind the result parameters using mysql_bind_result(). If you don't, mysql_stmt_fetch_column() will SEGFAULT at this line (libmysql/libmysql.c:4069 in MySQL 5.0.67):
*my_bind->length= *param->length;
...because "param" will be an invalid pointer.
Add your own comment.