COM_STMT_BULK_EXECUTE
You are viewing an old version of this article. View
the current version here.
Executes bulk insert a previously prepared statement.
(Since version 10.2.7) Command that return 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
- for each parameter :
- until end of packet
- for each parameter (i.e param_count times)
- byte<1>: parameter indicator
- if indicator == NONE
- byte<n> : binary parameter value
- for each parameter (i.e param_count times)
Flags
bulk flags
| 64 | Return generated auto-increment IDs |
| 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 one for insert, Is ignored for update |
COM_STMT_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.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
