mysql_stmt_fetch

mysql_stmt_fetch retrieves the next row from a prepared statement result set into the buffers bound by mysql_stmt_bind_result, returning MYSQL_NO_DATA at end of set.

Syntax

int mysql_stmt_fetch(MYSQL_STMT * stmt);

Parameter

Description

Fetch the result from a prepared statement into the buffer bound by mysql_stmt_bind_result().

Return Value

Returns 0 for success, MYSQL_NO_DATA if the end of the result set has been reached, or MYSQL_DATA_TRUNCATED if one or more values are truncated.

  • Note that all columns must be bound by the application before calling mysql_stmt_fetch().

  • Data are transferred unbuffered without calling mysql_stmt_store_result() which can decrease performance (but reduces memory cost).

  • Truncation reporting must be enabled by function mysql_optionsv() with option MYSQL_REPORT_DATA_TRUNCATION

See Also

spinner

Last updated

Was this helpful?