The optional result_mode parameter can be MYSQL_USE_RESULT and MYSQL_STORE_RESULT.
The optional result_mode parameter can be MYSQL_USE_RESULT and MYSQL_STORE_RESULT. It defaults to MYSQL_USE_RESULT, so the result is not buffered. See also mysql_query() for the counterpart of this behaviour.