> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_fetch_column.md).

# mysql\_stmt\_fetch\_column

## Syntax

```c
int mysql_stmt_fetch_column(MYSQL_STMT * stmt,
                            MYSQL_BIND * bind_arg,
                            unsigned int column,
                            unsigned long offset);
```

## Parameters

* `stmt` - a statement handle, which was previously allocated by [mysql\_stmt\_init()](/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_init.md).
* `bind_arg` - a pointer to a `MYSQL_BIND` structure.
* `column` - number of columns, first column is numbered zero.
* `offset` - offset at which to begin retrieving data.

## Description

This function can be used to fetch large data of a single column in pieces.

## Return Value

Returns zero on success, non-zero on failure.

{% hint style="info" %}
The size of the buffer is specified within `MYSQL_BIND` structure.
{% endhint %}

## See Also

* [mysql\_stmt\_fetch()](/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_fetch.md)
* [mysql\_stmt\_send\_long\_data()](/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_send_long_data.md)

{% @marketo/form formId="4316" %}