All pages
Powered by GitBook
1 of 1

Loading...

mysql_insert_id

Syntax

my_ulonglong mysql_insert_id(MYSQL * mysql);
  • mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Description

The mysql_insert_id() function returns the ID generated by a query on a table with a column having the attribute or the value for the last usage of . If the last query wasn't an or statement or if the modified table does not have a column with the attribute and was not used, this function will return zero.

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

See also

mysql_stmt_insert_id()
AUTO_INCREMENT
LAST_INSERT_ID(expr)
INSERT
UPDATE
AUTO_INCREMENT
LAST_INSERT_ID
AUTO INCREMENT
LAST_INSERT_ID()