All pages
Powered by GitBook
1 of 1

mysql_stmt_fetch

Syntax

int mysql_stmt_fetch(MYSQL_STMT * stmt);
  • stmt - a statement handle, which was previously allocated by mysql_stmt_init().

Description

Fetch the result from a prepared statement into the buffer bound by mysql_stmt_bind_result(). 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).

See Also

  • mysql_stmt_prepare()

  • mysql_stmt_bind_result()

  • mysql_stmt_execute()