mysql\_stmt\_sqlstate(3) MariaDB Connector/C mysql\_stmt\_sqlstate(3)

## [Name](#Name)

mysql\_stmt\_sqlstate - Returns SQLSTATE error from previous statement operation.

## [Synopsis](#Synopsis)

```
#include <mysql.h>
const char * mysql_stmt_sqlstate(MYSQL_STMT * stmt);
    
```

## [Description](#Description)

Returns a string containing the SQLSTATE error code for the most recently invoked prepared statement function that can succeed or fail. ## Parameter * stmt - a statement handle, which was previously allocated by [**mysql\_stmt\_init(3)**](/man/os/mariadb-12.3/mysql_stmt_init.3). ## Return value Returns a 5 digit error code. \`00000' means no error. The values are specified by ANSI SQL and ODBC.

## [Notes](#Notes)

Please note that not all client library error codes are mapped to SQLSTATE errors. Errors which can’t be mapped will returned as value HY000.

## [See Also](#See_Also)

•

[**mysql\_stmt\_errno(3)**](/man/os/mariadb-12.3/mysql_stmt_errno.3)

•

[**mysql\_stmt\_error(3)**](/man/os/mariadb-12.3/mysql_stmt_error.3)

Version 3.4

---

Document: mysql_stmt_sqlstate(3) from mariadb-12.3 12.3.3-r2 (Chainguard OS)
Source: https://github.com/MariaDB/server.git