Delete DB command package and analysis of mysql protocol-Mysql Tutorial-php.cn

Table of Contents

git

Overview

mysql communication message structure

Home

Database

Mysql Tutorial

Delete DB command package and analysis of mysql protocol

Mar 07, 2017 pm 01:51 PM

git

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

Overview

The mysql client tells the server to delete a certain schema by deleting the DB command package.

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

Delete DB command package

Payload

1              [06] COM_DROP_DBstring[EOF]    schema name

Copy after login

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

Delete DB command package operation

Delete DB command package class

/**
 * 
 * &lt;pre&gt;&lt;b&gt;mysql drop db packet.&lt;/b&gt;&lt;/pre&gt;
 * @author 
 * &lt;pre&gt;seaboat&lt;/pre&gt;
 * &lt;pre&gt;&lt;b&gt;email: &lt;/b&gt;849586227@qq.com&lt;/pre&gt;
 * &lt;pre&gt;&lt;b&gt;blog: &lt;/b&gt;http://www.php.cn/;/pre&gt;
 * @version 1.0
 * @see http://www.php.cn/
 */public class DropDBPacket extends MySQLPacket {
    public byte flag;    public byte[] schema;    @Override
    public void read(byte[] data) {
        MySQLMessage mm = new MySQLMessage(data);
        packetLength = mm.readUB3();
        packetId = mm.read();
        flag = mm.read();        this.schema = mm.readBytes();
    }    @Override
    public void write(ByteBuffer buffer) {
        BufferUtil.writeUB3(buffer, calcPacketSize());
        buffer.put(packetId);
        buffer.put(COM_DROP_DB);
        buffer.put(schema);
    }    @Override
    public int calcPacketSize() {        int i = 1;
        i += schema.length;        return i;
    }    @Override
    protected String getPacketInfo() {        return &quot;MySQL Drop DB Packet&quot;;
    }

}

Copy after login

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn