# mysql\_fetch\_fields

## Syntax

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

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

## Description

This function serves an identical purpose to the [mysql\_fetch\_field()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field) 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.

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

## See also

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

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