# mysql\_fetch\_lengths

## Syntax

```c
unsigned long * mysql_fetch_lengths(MYSQL_RES * result);
```

* `result` - 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

The mysql\_fetch\_lengths() function returns an array containing the lengths of every column of the current row within the result set (not including terminating zero character) or NULL if an error occurred.

{% hint style="info" %}
mysql\_fetch\_lengths() is valid only for the current row of the result set. It returns NULL if you call it before calling [mysql\_fetch\_row()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_row) or after retrieving all rows in the result.
{% endhint %}

## See also

* [mysql\_fetch\_row()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_row)

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