C API Prepared Statement Function Descriptions
2215
The use of
mysql_stmt_num_rows()
depends on whether you used
mysql_stmt_store_result()
to buffer the entire result set in the statement handle. If you use
mysql_stmt_store_result()
,
mysql_stmt_num_rows()
may be called immediately. Otherwise,
the row count is unavailable unless you count the rows as you fetch them.
mysql_stmt_num_rows()
is intended for use with statements that return a result set, such as
SELECT
. For statements such as
INSERT
,
UPDATE
, or
DELETE
, the number of affected rows can be
obtained with
mysql_stmt_affected_rows()
.
Return Values
The number of rows in the result set.
Errors
None.
20.6.10.18.
mysql_stmt_param_count()
unsigned long mysql_stmt_param_count(MYSQL_STMT *stmt)
Description
Returns the number of parameter markers present in the prepared statement.
Return Values
An unsigned long integer representing the number of parameters in a statement.
Errors
None.
Example
See the Example in
Section 20.6.10.10, “
mysql_stmt_execute()
”
.
20.6.10.19.
mysql_stmt_param_metadata()
MYSQL_RES *mysql_stmt_param_metadata(MYSQL_STMT *stmt)
This function currently does nothing.
Description
Return Values
Errors
20.6.10.20.
mysql_stmt_prepare()
int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long
length)
Description
Given the statement handle returned by
mysql_stmt_init()
, prepares the SQL statement pointed
to by the string
stmt_str
and returns a status value. The string length should be given by the
length
argument. The string must consist of a single SQL statement. You should not add a terminating
semicolon (“
;
”) or
\g
to the statement.
Содержание 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 ...