mysql\_stmt\_insert\_id(3) MariaDB Connector/C mysql\_stmt\_insert\_id(3)

## [Name](#Name)

mysql\_stmt\_insert\_id - Returns the auto generated id from previously executed prepared statement.

## [Synopsis](#Synopsis)

```
#include <mysql.h>
my_ulonglong mysql_stmt_insert_id(MYSQL_STMT * stmt);
    
```

## [Description](#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. ## Parameter * stmt - a statement handle, which was previously allocated by [**mysql\_stmt\_init(3)**](/man/enterprise-packages/mariadb-12.2/mysql_stmt_init.3). ## Return value Returns the auto generated id from previously executed prepared statement. 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.

## [Notes](#Notes)

•

When performing a multi insert prepared statement, mysql\_stmt\_insert\_id() will return the value of the first row.

## [See Also](#See_Also)

•

[**mysql\_insert\_id(3)**](/man/enterprise-packages/mariadb-12.2/mysql_insert_id.3)

Version 3.4

---

Document: mysql_stmt_insert_id(3) from mariadb-12.2 12.2.2-r11 (Chainguard OS)
Source: https://github.com/MariaDB/server.git