Introduction to the exit command package and parsing code of the mysql protocol-Mysql Tutorial-php.cn

Introduction to the exit command package and parsing code of the mysql protocol

黄舟

Release： 2017-03-07 14:03:30

Original

1430 people have browsed it

git

https://github.com/sea-boat/mysql-protocol

Overview

After the mysql client connects to the mysql server, when it needs to exit and disconnect, it sends an exit command to the server. The server can directly close the connection or return an OK packet.

mysql communication message structure

##string payloadMessage body, the length is the previously specified payload length

Type	Name	Description
int<3>	payload length	Stored according to the least significant byte first, 3-byte payload and 1-byte sequence number combination Into the message header
int<1>	sequence number

Exit command package

Payload

1              [01] COM_QUIT

Copy after login

More details: http://dev.mysql.com/doc/internals/en/com-quit.html

Quit Command package class

/**
 * 
 * @author seaboat
 * @date 2016-09-25
 * @version 1.0
 * <pre class="brush:php;toolbar:false"><b>email: </b>849586227@qq.com

<b>blog: </b>http://www.php.cn/;/pre>
 * <p>quit command packet.</p>
 */public class QuitPacket extends MySQLPacket {
    // payload length is 1,packet id is 0,payload is 1
    public static final byte[] QUIT = new byte[] { 1, 0, 0, 0, 1 };    @Override
    public int calcPacketSize() {        return 1;
    }    @Override
    protected String getPacketInfo() {        return "MySQL Quit Packet";
    }

}

Copy after login

The above is the introduction of the exit command package and parsing code of the mysql protocol. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!