COM_STMT_FETCH

This command fetches rows from an existing result set of a prepared statement that was executed with a cursor.

Fetch rows from a prepared statement.

A 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> 0x1C COM_STMT_FETCH header.

• int<4> statement id.

• int<4> number of rows to fetch.

Response

Returns one or more binary result set rows followed by an EOF packet.

_{This page is licensed: CC BY-SA / Gnu FDL}