mysql_insert_id
Prev Function reference Next

mysql_insert_id — Returns the auto generated id used in the last query

my_ulonglong mysql_insert_id(MYSQL * mysql);

The mysql_insert_id() function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero.

Parameters

mysql

A mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Return value

The value of the AUTO_INCREMENT field that was updated by the previous query. Returns zero if there was no previous query on the connection or if the query did not update an AUTO_INCREMENT value.

[Note]

Performing an INSERT or UPDATE statement using the LAST_INSERT_ID() function will also modify the value returned by the mysql_insert_id() function.

When performing a multi insert statement, mysql_insert_id() will return the value of the first row.

See also

mysql_stmt_insert_id()

Prev Up Next
mysql_init Home mysql_kill