mysql_stmt_insert_id
mysql_stmt_insert_id returns the AUTO_INCREMENT value generated by the most recent prepared INSERT or UPDATE statement, or zero if no auto-increment column was affected.
Syntax
my_ulonglong mysql_stmt_insert_id(MYSQL_STMT * stmt);Parameter
stmt- a statement handle, which was previously allocated by mysql_stmt_init().
Description
The mysql_stmt_insert_id() function returns the ID generated by a prepared statement 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.
Return Value
Returns the auto generated id from previously executed prepared statement.
See Also
This page is: Copyright © 2026 MariaDB. All rights reserved.
Last updated
Was this helpful?

