> 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_send_long_data.md).

# COM\_STMT\_SEND\_LONG\_DATA

When data for a specific column is large, it can be sent separately to avoid the limitation of `max_allowed_packet` (see [packet splitting](/docs/server/reference/clientserver-protocol/0-packet.md#packet-splitting)).

Multiple `COM_STMT_SEND_LONG_DATA` commands with the same column ID append the data. `COM_STMT_SEND_LONG_DATA` is sent before [COM\_STMT\_EXECUTE](/docs/server/reference/clientserver-protocol/3-binary-protocol-prepared-statements/com_stmt_execute.md).

## Fields

* [int<1>](/docs/server/reference/clientserver-protocol/protocol-data-types.md#fixed-length-integers) `0x18` `COM_STMT_SEND_LONG_DATA` header.
* [int<4>](/docs/server/reference/clientserver-protocol/protocol-data-types.md#fixed-length-integers) statement id.
* [int<2>](/docs/server/reference/clientserver-protocol/protocol-data-types.md#fixed-length-integers) parameter number.
* [byte\<EOF>](/docs/server/reference/clientserver-protocol/protocol-data-types.md#end-of-file-length-bytes) data.

## Response

Server doesn't send response.

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

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