'\" t
.\" Automatically generated by Pandoc 3.5
.\"
.TH "mysql_info" "3" "" "Version 3.3" "MariaDB Connector/C"
.SS Name
mysql_info \- provides information about the last executed statement
.SS Synopsis
.IP
.EX
#include \f[B]<mysql.h>\f[R]

const char * mysql_info(MYSQL * mysql);
.EE
.SS Description
The \f[CR]mysql_info()\f[R] function returns a string providing
information about the last statement executed.
.SS Parameter
.IP \[bu] 2
\f[CR]mysql\f[R] \- a connection identifier, which was previously
allocated by \f[B]mysql_init(3)\f[R] and connected by
\f[B]mysql_real_connect(3)\f[R].
.SS Notes
Statements which do not fall into one of the preceding formats are not
supported (e.g.\ \f[CR]SELECT\f[R]).
In these situations mysql_info() will return an empty string.
.SS Return value
Zero terminated information string.
The information depends on statement type:
.PP
.TS
tab(@);
lw(35.0n) lw(35.0n).
T{
Query type
T}@T{
Example result string
T}
_
T{
\f[CR]INSERT INTO...SELECT...\f[R]
T}@T{
Records: 100 Duplicates: 0 Warnings: 0
T}
T{
\f[CR]INSERT INTO...VALUES (...),(...),(...)\f[R]
T}@T{
Records: 3 Duplicates: 0 Warnings: 0
T}
T{
\f[CR]LOAD DATA INFILE\f[R]
T}@T{
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
T}
T{
\f[CR]ALTER TABLE ...\f[R]
T}@T{
Records: 3 Duplicates: 0 Warnings: 0
T}
T{
\f[CR]UPDATE ...\f[R]
T}@T{
Rows matched: 40 Changed: 40 Warnings: 0
T}
.TE
.SS See also
.IP \[bu] 2
\f[B]mysql_affected_rows(3)\f[R]
.IP \[bu] 2
\f[B]mysql_warning_count(3)\f[R]