Documentation Home
MySQL 5.7 C API Developer Guide
Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


6.4.27 mysql_stmt_sqlstate()

const char *mysql_stmt_sqlstate(MYSQL_STMT *stmt)

Description

For the statement specified bystmt,mysql_stmt_sqlstate() returns a null-terminated string containing the SQLSTATE error code for the most recently invoked prepared statement API function that can succeed or fail. The error code consists of five characters."00000" means“no error.” The values are specified by ANSI SQL and ODBC. For a list of possible values, seeError Messages and Common Problems.

Not all MySQL errors are mapped to SQLSTATE codes. The value"HY000" (general error) is used for unmapped errors.

If the failed statement API function wasmysql_stmt_close(), do not callmysql_stmt_sqlstate() to obtain error information becausemysql_stmt_close() makes the statement handler invalid. Callmysql_sqlstate() instead.

Return Values

A null-terminated character string containing the SQLSTATE error code.