# COM\_STMT\_FETCH

Fetch rows from a prepared statement.

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

## Fields

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

## Response

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

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

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