Oracle 5.0, Reference Manual

Page: 2207 / 3232

C API Function Descriptions
2187
An unknown error occurred.
20.6.6.66.
mysql_sqlstate()
const char *mysql_sqlstate(MYSQL *mysql)
Description
Returns a null-terminated string containing the SQLSTATE error code for the most recently executed
SQL statement. 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 C, Errors, Error Codes,
and Common Problems .
SQLSTATE values returned by
mysql_sqlstate()
differ from MySQL-specific error numbers
returned by
mysql_errno()
. For example, the
mysql
client program displays errors using the
following format, where
1146
is the
mysql_errno()
value and
'42S02'
is the corresponding
mysql_sqlstate()
value:
shell> SELECT * FROM no_such_table;
ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist
Not all MySQL error numbers are mapped to SQLSTATE error codes. The value
'HY000'
(general
error) is used for unmapped error numbers.
If you call
mysql_sqlstate()
after
mysql_real_connect()
fails,
mysql_sqlstate()
might not
return a useful value. For example, this happens if a host is blocked by the server and the connection is
closed without any SQLSTATE value being sent to the client.
Return Values
A null-terminated character string containing the SQLSTATE error code.
See Also
See Section 20.6.6.14, “
mysql_errno()
” , Section 20.6.6.15, “
mysql_error()
” , and
Section 20.6.10.26, “
mysql_stmt_sqlstate()
” .
20.6.6.67.
mysql_ssl_set()
my_bool mysql_ssl_set(MYSQL *mysql, const char *key, const char *cert, const
char *ca, const char *capath, const char *cipher)
Description
mysql_ssl_set()
is used for establishing secure connections using SSL. It must be called before
mysql_real_connect()
.
mysql_ssl_set()
does nothing unless SSL support is enabled in the client library.
mysql
is the connection handler returned from
mysql_init()
. The other parameters are specified as
follows:
•
key
is the path name to the key file.
•
cert
is the path name to the certificate file.
•
ca
is the path name to the certificate authority file.
•
capath
is the path name to a directory that contains trusted SSL CA certificates in PEM format.
•
cipher
is a list of permissible ciphers to use for SSL encryption.
Any unused SSL parameters may be given as
NULL
.