- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 17.6.7 C API Prepared Statement Function Descriptions
- 17.6.7.1 mysql_stmt_affected_rows()
- 17.6.7.2 mysql_stmt_attr_get()
- 17.6.7.3 mysql_stmt_attr_set()
- 17.6.7.4 mysql_stmt_bind_param()
- 17.6.7.5 mysql_stmt_bind_result()
- 17.6.7.6 mysql_stmt_close()
- 17.6.7.7 mysql_stmt_data_seek()
- 17.6.7.8 mysql_stmt_errno()
- 17.6.7.9 mysql_stmt_error()
- 17.6.7.10 mysql_stmt_execute()
- 17.6.7.11 mysql_stmt_fetch()
- 17.6.7.12 mysql_stmt_fetch_column()
- 17.6.7.13 mysql_stmt_field_count()
- 17.6.7.14 mysql_stmt_free_result()
- 17.6.7.15 mysql_stmt_init()
- 17.6.7.16 mysql_stmt_insert_id()
- 17.6.7.17 mysql_stmt_num_rows()
- 17.6.7.18 mysql_stmt_param_count()
- 17.6.7.19 mysql_stmt_param_metadata()
- 17.6.7.20 mysql_stmt_prepare()
- 17.6.7.21 mysql_stmt_reset()
- 17.6.7.22 mysql_stmt_result_metadata()
- 17.6.7.23 mysql_stmt_row_seek()
- 17.6.7.24 mysql_stmt_row_tell()
- 17.6.7.25 mysql_stmt_send_long_data()
- 17.6.7.26 mysql_stmt_sqlstate()
- 17.6.7.27 mysql_stmt_store_result()
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, see Appendix A, Errors, Error Codes, and Common Problems.
Note that not all MySQL errors are yet mapped to SQLSTATE codes.
The value "HY000" (general error) is used for
unmapped errors.
This function was added to MySQL 4.1.1.
Return Values
A null-terminated character string containing the SQLSTATE error code.
User Comments
Add your own comment.