# mysql\_stmt\_result\_metadata

## Syntax

```c
MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT * stmt);
```

* `stmt` - a statement handle, which was previously allocated by [mysql\_stmt\_init()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_init).

## Description

If a statement passed to [mysql\_stmt\_prepare()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_prepare) is one that produces a result set, `mysql_stmt_result_metadata()` returns the result set that can be used to process the meta information such as the total number of fields and individual field information.

{% hint style="info" %}
The result set returned by `mysql_stmt_result_metadata()` contains only metadata. It does not contain any row results. The rows are obtained by [mysql\_stmt\_fetch()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_fetch).\
This result set pointer can be passed as an argument to any of the field-based functions that process result set metadata, such as: [mysql\_num\_fields()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_num_fields), [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\_fetch\_fields()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_fields), [mysql\_field\_count()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_count), [mysql\_field\_seek()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_seek), [mysql\_field\_tell()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_tell), [mysql\_free\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_free_result)
{% endhint %}

## See Also

* [mariadb\_stmt\_fetch\_fields()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mariadb_stmt_fetch_fields)
* [mysql\_free\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_free_result)
* [mysql\_stmt\_prepare()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/mysql_stmt_prepare)

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