2024年6月15日发(作者：)

#700101 8:00:00 server id 1 end_log_pos 120 CRC32 0x199f2da4 Start: binlog v 4, server v 5.6.42-log created 700101 8:00:

# Warning: this binlog is either in use or was not closed properly.

BINLOG '

AAAAAA8BAAAAdAAAAHgAAAABAAQANS42LjQyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAaQt

nxk=

'/*!*/;

# at 120

#181104 15:18:37 server id 1 end_log_pos 192 CRC32 0x2224f8de Query thread_id=16 exec_time=0 error_code=0

SET TIMESTAMP=1541315917/*!*/;

SET @@_thread_id=16/*!*/;

SET @@n_key_checks=1, @@_auto_is_null=0, @@_checks=1, @@mmit=1/*!*/;

SET @@_mode=1075838976/*!*/;

BINLOG '

TZ3eWxMBAAAAPAAAAPwAAAAAAFUAAAAAAAEABHRlc3QABnBlcnNvbgAGAw/+DwMDBgoA/gEKAD47

vvtl

TZ3eWyABAAAAtwAAALMBAAAAAFUAAAAAAAEAAgAG/8ABAAAAAmppATEDd2VyqEA0AGpqyADAAgAA

AANsdW8BMQN3ZXKcQjQAJ2zZAMADAAAAAnl1ATAEamVndfombwA3JyEBwAQAAAACZGEBMAdiZWlq

aW5nOgZQAFfZQADABQAAAAJnagEwB2JlaWppbmcSBlAAh+jOAMAGAAAABHlhbmcBMAduYW5qaW5n

cg5MAIdSqwo5G10A

'/*!*/;

### DELETE FROM `test`.`person`

### WHERE

### @1=1 /* INT meta=0 nullable=0 is_null=0 */

/*!C latin1 *//*!*/;

SET @@ter_set_client=8,@@ion_connection=8,@@ion_server=8/*!*/;

SET @@_time_names=0/*!*/;

SET @@ion_database=DEFAULT/*!*/;

BEGIN

/*!*/;

# at 192

#181104 15:18:37 server id 1 end_log_pos 252 CRC32 0x65fbbe3b Table_map: `test`.`person` mapped to number 85

# at 252

#181104 15:18:37 server id 1 end_log_pos 435 CRC32 0x005d1b39 Delete_rows: table id 85 flags: STMT_END_F

SET @@_increment_increment=1, @@_increment_offset=1/*!*/;

00

### @2='ji' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='1' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @5=3424424 /* INT meta=0 nullable=1 is_null=0 */

### @6=13134442 /* INT meta=0 nullable=1 is_null=0 */

### DELETE FROM `test`.`person`

### WHERE

### @1=2 /* INT meta=0 nullable=0 is_null=0 */

### @2='luo' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='1' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @4='wer' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @5=3424924 /* INT meta=0 nullable=1 is_null=0 */

### @6=14248999 /* INT meta=0 nullable=1 is_null=0 */

### DELETE FROM `test`.`person`

### WHERE

### @1=3 /* INT meta=0 nullable=0 is_null=0 */

### @2='yu' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='0' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @4='jegu' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @5=7284474 /* INT meta=0 nullable=1 is_null=0 */

### @6=18949943 /* INT meta=0 nullable=1 is_null=0 */

### DELETE FROM `test`.`person`

### WHERE

### @1=4 /* INT meta=0 nullable=0 is_null=0 */

### @2='da' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='0' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @4='wer' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @4='beijing' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @5=5244474 /* INT meta=0 nullable=1 is_null=0 */

### @6=4249943 /* INT meta=0 nullable=1 is_null=0 */

### DELETE FROM `test`.`person`

### WHERE

### @1=5 /* INT meta=0 nullable=0 is_null=0 */

### @2='gj' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='0' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @4='beijing' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @5=5244434 /* INT meta=0 nullable=1 is_null=0 */

### @6=13559943 /* INT meta=0 nullable=1 is_null=0 */

### DELETE FROM `test`.`person`

### WHERE

### @1=6 /* INT meta=0 nullable=0 is_null=0 */

### @2='yang' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @3='0' /* STRING(1) meta=65025 nullable=1 is_null=0 */

### @4='nanjing' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */

### @5=4984434 /* INT meta=0 nullable=1 is_null=0 */

### @6=178999943 /* INT meta=0 nullable=1 is_null=0 */

# at 435

#181104 15:18:37 server id 1 end_log_pos 466 CRC32 0xab85d971 Xid = 197

COMMIT/*!*/;

# at 466

#181104 15:19:38 server id 1 end_log_pos 538 CRC32 0x8b9e1093 Query thread_id=16 exec_time=0 error_code=0

SET TIMESTAMP=1541315978/*!*/;

BEGIN

/*!*/;

# at 538

#181104 15:19:38 server id 1 end_log_pos 598 CRC32 0xb1679f78 Table_map: `test`.`person` mapped to number 85

# at 598

#181104 15:19:38 server id 1 end_log_pos 656 CRC32 0xa5d7a2d6 Write_rows: table id 85 flags: STMT_END_F