---
name: "mysql_num_rows"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_num_rows"
---

# mysql\_num\_rows(3)

### Name

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

### Synopsis

-

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

### Description

Returns number of rows in a result set.

### Parameters

- •

  `MYSQL_RES` - a result set identifier returned by **[mysql\_store\_result(3)](/mysql_store_result/3.md)** or **[mysql\_use\_result(3)](/mysql_use_result/3.md)**. ### 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

- •

  **[mysql\_affected\_rows(3)](/mysql_affected_rows/3.md)**

- •

  **[mysql\_use\_result(3)](/mysql_use_result/3.md)**

- •

  **[mysql\_store\_result(3)](/mysql_store_result/3.md)**