COM_QUERY
You are viewing an old version of this article. View
the current version here.
COM_QUERY
With the COM_QUERY command, the client sends the server an SQL statement to be executed immediately.
Fields
- int<1> 0x03 : COM_QUERY header
- string<EOF> SQL statement
Response
server can answer with 4 differents responses that can be differentiated by the first byte (packet header)
- 0xFF - ERR_Packet if any error occur
- 0x00 - OK_packet when query execution works without resultset
- 0xFB - LOCAL_INFILE Packet if query was "LOCAL INFILE ..."
- Or a Resultset, when query execution works with resultset (in case of SELECT query for example)
ERR_Packet
Example
| 1b 00 00 00 03 44 52 4f 50 20 54 41 42 4c 45 20 | .....DROP TABLE |
| 49 46 20 45 58 49 53 54 53 20 62 75 6c 6b 31 | IF EXISTS bulk1 |
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.
