MySQL :: MySQL Internals Manual :: 14.1.6 Command Phase

MySQL Internals Manual / ... / Command Phase

14.1.6 Command Phase

In the command phase, the client sends a command packet with the sequence-id [00]:

13 00 00 00 03 53 ...
01 00 00 00 01
            ^^- command-byte
         ^^---- sequence-id == 0

The first byte of the payload describes the command-type like:

Hex	Constant Name
00	`COM_SLEEP`
01	`COM_QUIT`
02	`COM_INIT_DB`
03	`COM_QUERY`
04	`COM_FIELD_LIST`
05	`COM_CREATE_DB`
06	`COM_DROP_DB`
07	`COM_REFRESH`
08	`COM_SHUTDOWN`
09	`COM_STATISTICS`
0a	`COM_PROCESS_INFO`
0b	`COM_CONNECT`
0c	`COM_PROCESS_KILL`
0d	`COM_DEBUG`
0e	`COM_PING`
0f	`COM_TIME`
10	`COM_DELAYED_INSERT`
11	`COM_CHANGE_USER`
12	`COM_BINLOG_DUMP`
13	`COM_TABLE_DUMP`
14	`COM_CONNECT_OUT`
15	`COM_REGISTER_SLAVE`
16	`COM_STMT_PREPARE`
17	`COM_STMT_EXECUTE`
18	`COM_STMT_SEND_LONG_DATA`
19	`COM_STMT_CLOSE`
1a	`COM_STMT_RESET`
1b	`COM_SET_OPTION`
1c	`COM_STMT_FETCH`
1d	`COM_DAEMON`
1e	`COM_BINLOG_DUMP_GTID`
1f	`COM_RESET_CONNECTION`

The commands belong to:

PREV HOME UP NEXT

User Comments

User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.