In addition to the result set returned by a query, you can also get the following information:
mysql_affected_rows()returns the number of rows affected by the last query when doing an
For a fast re-create, use
mysql_num_rows()returns the number of rows in a result set. With
mysql_num_rows()may be called as soon as
mysql_num_rows()may be called only after you have fetched all the rows with
mysql_insert_id()returns the ID generated by the last query that inserted a row into a table with an
AUTO_INCREMENTindex. See Section 5.4.42, “mysql_insert_id()”.
Some queries (
INSERT INTO ... SELECT,
UPDATE) return additional information. The result is returned by
mysql_info(). See the description for
mysql_info()for the format of the string that it returns.
NULLpointer if there is no additional information.