mysql_stmt_store_result

Syntax

int mysql_stmt_store_result(MYSQL_STMT * stmt);

• stmt - a statement handle, which was previously allocated by mysql_stmt_init().

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_stmt_fetch() call returns buffered data.

Returns zero on success, nonzero if an error occurred.

You can detect whether the statement produced a result set by checking the return value of mysql_stmt_result_metadata() function.

See Also

• mysql_stmt_result_metadata()

• mysql_stmt_fetch()