> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/clientserver-protocol/3-binary-protocol-prepared-statements/com_stmt_fetch.md).

# COM\_STMT\_FETCH

Fetch rows from a prepared statement.

A [COM\_STMT\_EXECUTE](/docs/server/reference/clientserver-protocol/3-binary-protocol-prepared-statements/com_stmt_execute.md) with a non-zero cursor flag must have been successfully executed before any `COM_STMT_FETCH` commands can be executed.

## Fields

* [int<1>](/docs/server/reference/clientserver-protocol/protocol-data-types.md) 0x1C COM\_STMT\_FETCH header.
* [int<4>](/docs/server/reference/clientserver-protocol/protocol-data-types.md) statement id.
* [int<4>](/docs/server/reference/clientserver-protocol/protocol-data-types.md) number of rows to fetch.

## Response

Returns one or more [binary result set rows](/docs/server/reference/clientserver-protocol/4-server-response-packets/resultset-row.md#binary-resultset-row) followed by an [EOF packet](/docs/server/reference/clientserver-protocol/4-server-response-packets/eof_packet.md).

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}