MySQL Manual
9 MySQL APIs
- 9.1 MySQL C API
- 9.1.7 C API Prepared Statement Function Descriptions
- 9.1.7.1
mysql_prepare() - 9.1.7.2
mysql_param_count() - 9.1.7.3
mysql_prepare_result() - 9.1.7.4
mysql_bind_param() - 9.1.7.5
mysql_execute() - 9.1.7.6
mysql_stmt_affected_rows() - 9.1.7.7
mysql_bind_result() - 9.1.7.8
mysql_stmt_store_result() - 9.1.7.9
mysql_stmt_data_seek() - 9.1.7.10
mysql_stmt_row_seek() - 9.1.7.11
mysql_stmt_row_tell() - 9.1.7.12
mysql_stmt_num_rows() - 9.1.7.13
mysql_fetch() - 9.1.7.14
mysql_send_long_data() - 9.1.7.15
mysql_stmt_close() - 9.1.7.16
mysql_stmt_errno() - 9.1.7.17
mysql_stmt_error() - 9.1.7.18
mysql_stmt_sqlstate()
- 9.1.7.1
9.1.7.8 mysql_stmt_store_result()
int mysql_stmt_store_result(MYSQL_STMT *stmt)
Description
You must call mysql_stmt_store_result() for every query that
successfully produces a result set
(SELECT, SHOW, DESCRIBE, EXPLAIN), and only
if you want to buffer the complete result set by the client, so that the
subsequent mysql_fetch() call returns buffered data.
It is unnecessary to call mysql_stmt_store_result() for other
queries, but if you do, it will not harm or cause any notable performance in all
cases. You can detect whether the query produced a result set by checking
if mysql_prepare_result() returns NULL. For more information, refer
to section 9.1.7.3 mysql_prepare_result().
Return Values
Zero if the results are buffered successfully. Non-zero if an error occurred.
Errors
CR_COMMANDS_OUT_OF_SYNC- Commands were executed in an improper order.
CR_OUT_OF_MEMORY- Out of memory.
CR_SERVER_GONE_ERROR- The MySQL server has gone away.
CR_SERVER_LOST- The connection to the server was lost during the query.
CR_UNKNOWN_ERROR- An unknown error occurred.
