MySQL :: MySQL 8.4 C API Developer Guide :: 6.4.28 mysql_stmt_sqlstate() (original) (raw)

The world's most popular open source database

6.4.28 mysql_stmt_sqlstate()

const char *
mysql_stmt_sqlstate(MYSQL_STMT *stmt)

Description

For the statement specified by stmt,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 call mysql_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.