7.3.13.1 mysqli_sql_exception::getSqlState

Copyright 1997-2022 the PHP Documentation Group.

• mysqli_sql_exception::getSqlState

  Returns the SQLSTATE error code

Description

public string mysqli_sql_exception::getSqlState();

Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. The values are specified by ANSI SQL and ODBC. For a list of possible values, see http://dev.mysql.com/doc/mysql/en/error-handling.html.

Note

Note that not all MySQL errors are yet mapped to SQLSTATE's. The value HY000 (general error) is used for unmapped errors.

Parameters

This function has no parameters.

Return Values

Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters.