Table of Contents for

MySQL in a Nutshell, 2nd Edition

This function returns a string containing information provided by MySQL when certain SQL statements are executed. This function works with only five types of SQL statements: INSERT INTO...SELECT..., INSERT INTO... VALUES..., LOAD DATA INFILE, ALTER TABLE, and UPDATE. For all other statements, this function typically returns NULL. Here is an example:

...
mysql_query(mysql, "UPDATE clients
                    SET telephone_areacode = '985'
                    WHERE city = 'Hammond'");
printf("Query Info: %s \n", mysql_info(mysql));
...

The results of this program excerpt will look like the following:

Query Info: Rows matched: 3  Changed: 3  Warnings: 0