---
name: "mysql_stmt_sqlstate"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_stmt_sqlstate"
---

# mysql\_stmt\_sqlstate(3)

### Name

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

### Synopsis

-

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

### 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)](/mysql_stmt_init/3.md)**. ## Return value Returns a 5 digit error code. \`00000' means no error. The values are specified by ANSI SQL and ODBC.

### 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

- •

  **[mysql\_stmt\_errno(3)](/mysql_stmt_errno/3.md)**

- •

  **[mysql\_stmt\_error(3)](/mysql_stmt_error/3.md)**