> 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-functions/mysql_fetch_fields.md).

# mysql\_fetch\_fields

## Syntax

```c
MYSQL_FIELD * mysql_fetch_fields(MYSQL_RES * res);
```

## Parameter

* `res` - a result set identifier returned by [mysql\_store\_result()](/docs/connectors/mariadb-connector-c/api-functions/mysql_store_result.md) or [mysql\_use\_result()](/docs/connectors/mariadb-connector-c/api-functions/mysql_use_result.md).

## Description

This function serves an identical purpose to the [mysql\_fetch\_field()](/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field.md) function with the single difference that instead of returning one field at a time for each field, the fields are returned as an array. Each field contains the definition for a column of the result set.

## Return Value

An array of type `MYSQL_FIELD`.

{% hint style="info" %}
The total number of fields can be obtained by [mysql\_field\_count()](/docs/connectors/mariadb-connector-c/api-functions/mysql_field_count.md).
{% endhint %}

## See Also

* [mysql\_fetch\_field()](/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field.md)
* [mysql\_fetch\_field\_direct()](/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field_direct.md)
* [mysql\_field\_count()](/docs/connectors/mariadb-connector-c/api-functions/mysql_field_count.md)

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