mysql_info

Syntax

const char * mysql_info(MYSQL * mysql);

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 typeExample 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

Comments

Comments loading...
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.