mysql\_num\_rows(3) MariaDB Connector/C mysql\_num\_rows(3)

## [Name](#Name)

mysql\_num\_rows - Returns number of rows in a result set.

## [Synopsis](#Synopsis)

```
#include <mysql.h>
my_ulonglong mysql_num_rows(MYSQL_RES * );
    
```

## [Description](#Description)

Returns number of rows in a result set.

## [Parameters](#Parameters)

•

MYSQL\_RES - a result set identifier returned by [**mysql\_store\_result(3)**](/man/os/mariadb-11.6/mysql_store_result.3) or [**mysql\_use\_result(3)**](/man/os/mariadb-11.6/mysql_use_result.3). ### Notes The behaviour 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 correct number of rows until all the rows in the result have been retrieved.

## [See also](#See_also)

•

[**mysql\_affected\_rows(3)**](/man/os/mariadb-11.6/mysql_affected_rows.3)

•

[**mysql\_use\_result(3)**](/man/os/mariadb-11.6/mysql_use_result.3)

•

[**mysql\_store\_result(3)**](/man/os/mariadb-11.6/mysql_store_result.3)

Version 3.4

---

Document: mysql_num_rows(3) from mariadb-11.6 11.6.2-r0 (Chainguard OS)