mysqlbinlog.exe 下载 适用8.0版本
https://wwd.lanzoub.com/iO5by091g32h
在bin目录执行
mysqlbinlog.exe --no-defaults -vv --base64-output=decode-rows "C:\phpstudy_pro\Extensions\MySQL8.0.12\data\binlog.000017" >mysqlbinbibinbinbbin.log
# The proper term is pseudo_replica_mode, but we use this compatibility alias # to make the statement usable on server versions 8.0.24 and older. /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #220805 12:27:39 server id 1 end_log_pos 124 CRC32 0xb51bf591 Start: binlog v 4, server v 8.0.12 created 220805 12:27:39 at startup ROLLBACK/*!*/; # at 124 #220805 12:27:39 server id 1 end_log_pos 155 CRC32 0x897dc175 Previous-GTIDs # [empty] # at 155 #220805 12:38:38 server id 1 end_log_pos 230 CRC32 0x75cee8b5 Anonymous_GTID last_committed=0 sequence_number=1 rbr_only=yes original_committed_timestamp=1659674318295850 immediate_commit_timestamp=1659674318295850 transaction_length=554 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; # original_commit_timestamp=1659674318295850 (2022-08-05 12:38:38.295850 Öйú±ê׼ʱ¼ä) # immediate_commit_timestamp=1659674318295850 (2022-08-05 12:38:38.295850 Öйú±ê׼ʱ¼ä) /*!80001 SET @@session.original_commit_timestamp=1659674318295850*//*!*/; /*!80014 SET @@session.original_server_version=999999*//*!*/; /*!80014 SET @@session.immediate_server_version=999999*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 230 #220805 12:38:38 server id 1 end_log_pos 323 CRC32 0x6fb8b723 Query thread_id=11 exec_time=0 error_code=0 SET TIMESTAMP=1659674318/*!*/; SET @@session.pseudo_thread_id=11/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1168113696/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=192/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/; BEGIN /*!*/; # at 323 #220805 12:38:38 server id 1 end_log_pos 426 CRC32 0x00a57d2c Table_map: `liangdong-hao`.`agent_account` mapped to number 72 # at 426 #220805 12:38:38 server id 1 end_log_pos 678 CRC32 0x669f89b4 Update_rows: table id 72 flags: STMT_END_F ### UPDATE `liangdong-hao`.`agent_account` ### WHERE ### @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @2=3 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @3=0 /* INT meta=0 nullable=1 is_null=0 */ ### @4=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @5=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @6=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @7=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @8=3.170 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @9=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @10=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @11='bec5508bc8bf3ed621c034c832cd1ed3' /* VARSTRING(128) meta=128 nullable=1 is_null=0 */ ### @12='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */ ### @13='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */ ### SET ### @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @2=31 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @3=0 /* INT meta=0 nullable=1 is_null=0 */ ### @4=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @5=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @6=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @7=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @8=3.170 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @9=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @10=0.000 /* DECIMAL(12,3) meta=3075 nullable=1 is_null=0 */ ### @11='bec5508bc8bf3ed621c034c832cd1ed3' /* VARSTRING(128) meta=128 nullable=1 is_null=0 */ ### @12='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */ ### @13='2022-04-08 00:30:29' /* DATETIME(0) meta=0 nullable=1 is_null=0 */ # at 678 #220805 12:38:38 server id 1 end_log_pos 709 CRC32 0xf55ba82f Xid = 67 COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;