Linux - icdiff

 

frank@ZZHPC:/mnt/d/WSL_shared$ sudo apt install icdiff

 

frank@ZZHPC:/mnt/d/WSL_shared$ icdiff -N 1.txt 2.txt
1.txt                                                                              2.txt
     102 ###   @1=1                                                                     102 ###   @1=1
     103 ###   @2='aaa'                                                                 103 ###   @2='aaa'
     104 # at 1023                                                                      104 # at 1023
     105 #251222  3:29:20 server id 1  end_log_pos 1054 CRC32 0x99b881ce         X      105 #251222  3:29:20 server id 1  end_log_pos 1054 CRC32 0x99b881ce         X
id = 77                                                                            id = 77
     106 COMMIT/*!*/;                                                                   106 COMMIT/*!*/;
                                                                                        107 # at 1054\r
                                                                                        108 #251222  3:52:11 server id 1  end_log_pos 1133 CRC32 0xc7ce51fd         A
                                                                                   nonymous_GTID  last_committed=3        sequence_number=4       rbr_only=n
                                                                                   o     original_committed_timestamp=1766375531195211 immediate_commit_time
                                                                                   stamp=1766375531195211     transaction_length=305\r
                                                                                        109 # original_commit_timestamp=1766375531195211 (2025-12-22 03:52:11.195211
                                                                                   UTC)\r
                                                                                        110 # immediate_commit_timestamp=1766375531195211 (2025-12-22 03:52:11.195211
                                                                                    UTC)\r
                                                                                        111 /*!80001 SET @@session.original_commit_timestamp=1766375531195211*//*!*/;
                                                                                   \r
                                                                                        112 /*!80014 SET @@session.original_server_version=90400*//*!*/;\r
                                                                                        113 /*!80014 SET @@session.immediate_server_version=90400*//*!*/;\r
                                                                                        114 SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;\r
                                                                                        115 # at 1133\r
                                                                                        116 #251222  3:52:11 server id 1  end_log_pos 1359 CRC32 0xb31b3402         Q
                                                                                   uery   thread_id=11    exec_time=0     error_code=0    Xid = 85\r
                                                                                        117 SET TIMESTAMP=1766375531/*!*/;\r
                                                                                        118 /*!80016 SET @@session.default_table_encryption=0*//*!*/;\r
                                                                                        119 /* ApplicationName=DBeaver 25.3.1 - Main */ CREATE SCHEMA `test_db`\r
                                                                                        120 DEFAULT CHARACTER SET utf8mb4\r
                                                                                        121 DEFAULT COLLATE utf8mb4_0900_ai_ci\r
                                                                                        122 /*!*/;\r
                                                                                        123 # at 1359\r
                                                                                        124 #251222  3:55:12 server id 1  end_log_pos 1438 CRC32 0xde6abf7e         A
                                                                                   nonymous_GTID  last_committed=4        sequence_number=5       rbr_only=n
                                                                                   o     original_committed_timestamp=1766375712879511 immediate_commit_time
                                                                                   stamp=1766375712879511     transaction_length=285\r
                                                                                        125 # original_commit_timestamp=1766375712879511 (2025-12-22 03:55:12.879511
                                                                                   UTC)\r
                                                                                        126 # immediate_commit_timestamp=1766375712879511 (2025-12-22 03:55:12.879511
                                                                                    UTC)\r
                                                                                        127 /*!80001 SET @@session.original_commit_timestamp=1766375712879511*//*!*/;
                                                                                   \r
                                                                                        128 /*!80014 SET @@session.original_server_version=90400*//*!*/;\r
                                                                                        129 /*!80014 SET @@session.immediate_server_version=90400*//*!*/;\r
                                                                                        130 SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;\r
                                                                                        131 # at 1438\r
                                                                                        132 #251222  3:55:12 server id 1  end_log_pos 1644 CRC32 0xb1e86d8d         Q
                                                                                   uery   thread_id=16    exec_time=0     error_code=0    Xid = 110\r
                                                                                        133 use `test_db`/*!*/;\r
                                                                                        134 SET TIMESTAMP=1766375712/*!*/;\r
                                                                                        135 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;\r
                                                                                        136 /* ApplicationName=DBeaver 25.3.1 - SQLEditor <Script-2.sql> */ CREATE TA
                                                                                   BLE ztest_2(name VARCHAR(100), age INT)\r
                                                                                        137 /*!*/;\r
     107 SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;         138 SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
     108 DELIMITER ;                                                                    139 DELIMITER ;
     109 # End of log file                                                              140 # End of log file
     110 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;                           141 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
     111 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;                                  142 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;