---
name: "mysql_info"
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_info"
---

# mysql\_info(3)

### Name

mysql\_info - provides information about the last executed statement

### Synopsis

-

  ```
  #include <mysql.h>
  const char * mysql_info(MYSQL * mysql);
  ```

### Description

The `mysql_info()` function returns a string providing information about the last statement executed.

### Parameter

- •

  `mysql` - a connection identifier, which was previously allocated by **[mysql\_init(3)](/mysql_init/3.md)** and connected by **[mysql\_real\_connect(3)](/mysql_real_connect/3.md)**.

### Notes

Statements which do not fall into one of the preceding formats are not supported (e.g. `SELECT`). In these situations mysql\_info() will return an empty string.

### Return value

Zero terminated information string. The information depends on statement type:

| | |
| --- | --- |
| Query type | Example result string |
| `INSERT INTO...SELECT...` | Records: 100 Duplicates: 0 Warnings: 0 |
| `INSERT INTO...VALUES (...),(...),(...)` | Records: 3 Duplicates: 0 Warnings: 0 |
| `LOAD DATA INFILE` | Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 |
| `ALTER TABLE ...` | Records: 3 Duplicates: 0 Warnings: 0 |
| `UPDATE ...` | Rows matched: 40 Changed: 40 Warnings: 0 |

### See also

- •

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

- •

  **[mysql\_warning\_count(3)](/mysql_warning_count/3.md)**