mysql_use_result - Man Page


mysql_use_result - returns an unbuffered result set


#include <nysql.h>

MYSQL_RES * mysql_use_result(MYSQL * mysql);


Used to initiate the retrieval of a result set from the last query executed using the mysql_real_query() function on the database connection. Either this or the mysql_store_result(3) function must be called before the results of a query can be retrieved, and one or the other must be called to prevent the next query on that database connection from failing.



The mysql_use_result() function does not transfer the entire result set. Hence several functions like mysql_num_rows(3) or mysql_data_seek(3) cannot be used. mysql_use_result() will block the current connection until all result sets are retrieved or result set was released by mysql_free_result(3).

Return value

Returns an unbuffered result set or NULL if an error occurred.

See also

Referenced By

mysql_fetch_field(3), mysql_fetch_field_direct(3), mysql_fetch_fields(3), mysql_fetch_lengths(3), mysql_fetch_row(3), mysql_field_count(3), mysql_field_seek(3), mysql_field_tell(3), mysql_free_result(3), mysql_more_results(3), mysql_next_result(3), mysql_num_fields(3), mysql_num_rows(3), mysql_query(3), mysql_real_query(3), mysql_row_seek(3), mysql_row_tell(3), mysql_stmt_row_seek(3), mysql_store_result(3).

Version 3.2.2 MariaDB Connector/C