COM_QUERY

You are viewing an old version of this article. View the current version here.

COM_QUERY (0x03)

With the COM_QUERY command, the client sends the server an SQL statement to be executed immediately.

Fields

int_1      COM_QUERY 0x03
str_REST   SQL statement

Response

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

Notes

Since SQL statements in text protocol may contain binary characters protocol type str_NUL can't be used. The length of the SQL statement can be calculated by package_size - 1.

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.