mysql_info
Syntax
const char * mysql_info(MYSQL * mysql);
mysql- a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().
Description
The mysql_info() function returns a string providing information about the last query executed. The nature of this string is provided below:
Table 1. Possible mysql_info return values
| 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 |
Queries 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.
See also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
