- 21.9.7 C API Prepared Statement Function Descriptions
- 21.9.7.1 mysql_stmt_affected_rows()
- 21.9.7.2 mysql_stmt_attr_get()
- 21.9.7.3 mysql_stmt_attr_set()
- 21.9.7.4 mysql_stmt_bind_param()
- 21.9.7.5 mysql_stmt_bind_result()
- 21.9.7.6 mysql_stmt_close()
- 21.9.7.7 mysql_stmt_data_seek()
- 21.9.7.8 mysql_stmt_errno()
- 21.9.7.9 mysql_stmt_error()
- 21.9.7.10 mysql_stmt_execute()
- 21.9.7.11 mysql_stmt_fetch()
- 21.9.7.12 mysql_stmt_fetch_column()
- 21.9.7.13 mysql_stmt_field_count()
- 21.9.7.14 mysql_stmt_free_result()
- 21.9.7.15 mysql_stmt_init()
- 21.9.7.16 mysql_stmt_insert_id()
- 21.9.7.17 mysql_stmt_next_result()
- 21.9.7.18 mysql_stmt_num_rows()
- 21.9.7.19 mysql_stmt_param_count()
- 21.9.7.20 mysql_stmt_param_metadata()
- 21.9.7.21 mysql_stmt_prepare()
- 21.9.7.22 mysql_stmt_reset()
- 21.9.7.23 mysql_stmt_result_metadata()
- 21.9.7.24 mysql_stmt_row_seek()
- 21.9.7.25 mysql_stmt_row_tell()
- 21.9.7.26 mysql_stmt_send_long_data()
- 21.9.7.27 mysql_stmt_sqlstate()
- 21.9.7.28 mysql_stmt_store_result()
my_ulonglong mysql_stmt_num_rows(MYSQL_STMT
*stmt)
Description
Returns the number of rows in the result set.
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.
User Comments
Add your own comment.