# mysql\_num\_rows

## Syntax

```c
my_ulonglong mysql_num_rows(MYSQL_RES * );
```

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

Returns number of rows in a result set.

{% hint style="info" %}
The behavior of `mysql_num_rows()` depends on whether buffered or unbuffered result sets are being used. For unbuffered result sets, `mysql_num_rows()` will not return the correbct number of rows until all the rows in the result have been retrieved.
{% endhint %}

## See also

* [mysql\_affected\_rows()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_affected_rows)
* [mysql\_use\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_use_result)
* [mysql\_store\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_store_result)

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