COM_STMT_BULK_EXECUTE

Executes a bulk insert of a previously prepared statement.

A command that returns a resultset will return an error (Error packet).

Direction

Client to server.

Fields

• int<1> 0xfa : COM_STMT_BULK_EXECUTE header

• int<4> statement id

• int<2> bulk flags

• if (bulk_flag & SEND_TYPES_TO_SERVER)

  • for each parameter :

    • byte<1>: field type

    • byte<1>: parameter type flag

• until end of packet

  • for each parameter (i.e param_count times)

    • byte<1>: parameter indicator

    • if indicator == NONE

      • byte : binary parameter value

Flags

bulk flags

SEND_UNIT_RESULTS	64	Return generated affected rows and auto-increment IDs as a resultset (only when server supports MARIADB_CLIENT_BULK_UNIT_RESULTS capability)
SEND_TYPES_TO_SERVER	128	Send types to server

parameter type flag:

128	unsigned

parameter indicator

0	NONE	Value follow
1	NULL	Value is null
2	DEFAULT	For INSERT/UPDATE, value is default
3	IGNORE	Value is default for insert, Is ignored for update

COM_STMT_BULK_EXECUTE response

The server can answer with 3 different responses:

• 0xff: ERR_Packet if any errors occur.

• 0x00: OK_packet when query execution works without resultset.

• a resultset containing affected rows and auto-increment IDs when bulk flag SEND_UNIT_RESULTS is set

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