C API Function Descriptions
2188
Return Values
This function always returns
0
. If SSL setup is incorrect,
mysql_real_connect()
returns an error
when you attempt to connect.
20.6.6.68.
mysql_stat()
const char *mysql_stat(MYSQL *mysql)
Description
Returns a character string containing information similar to that provided by the
mysqladmin status
command. This includes uptime in seconds and the number of running threads, questions, reloads, and
open tables.
Return Values
A character string describing the server status.
NULL
if an error occurred.
Errors
•
CR_COMMANDS_OUT_OF_SYNC
[2942]
Commands were executed in an improper order.
•
CR_SERVER_GONE_ERROR
[2942]
The MySQL server has gone away.
•
CR_SERVER_LOST
[2942]
The connection to the server was lost during the query.
•
CR_UNKNOWN_ERROR
[2941]
An unknown error occurred.
20.6.6.69.
mysql_store_result()
MYSQL_RES *mysql_store_result(MYSQL *mysql)
Description
After invoking
mysql_query()
or
mysql_real_query()
, you must call
mysql_store_result()
or
mysql_use_result()
for every statement that successfully produces a result set (
SELECT
,
SHOW
,
DESCRIBE
,
EXPLAIN
,
CHECK TABLE
, and so forth). You must also call
mysql_free_result()
after
you are done with the result set.
You don't have to call
mysql_store_result()
or
mysql_use_result()
for other
statements, but it does not do any harm or cause any notable performance degradation if you call
mysql_store_result()
in all cases. You can detect whether the statement has a result set by
checking whether
mysql_store_result()
returns a nonzero value (more about this later).
If you enable multiple-statement support, you should retrieve results from calls to
mysql_query()
or
mysql_real_query()
by using a loop that calls
mysql_next_result()
to determine whether
there are more results. For an example, see
Section 20.6.15, “C API Support for Multiple Statement
Execution”
.
If you want to know whether a statement should return a result set, you can use
mysql_field_count()
to check for this. See
Section 20.6.6.22, “
mysql_field_count()
”
.
mysql_store_result()
reads the entire result of a query to the client, allocates a
MYSQL_RES
structure, and places the result into this structure.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...