解析出来的数据不对

[1450793561]

表结构：

CREATE TABLE `demo` (
  `AutoId` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
  `UserMongoId` varchar(32) NOT NULL DEFAULT '' COMMENT 'UserId',
  `name` char(11) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`AutoId`),
  UNIQUE KEY `uniq_idx_UserMongoId` (`UserMongoId`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED COMMENT='基本信息'

数据如下：

解析出来的sql不对，没列的值都颠倒了，age、UserMongoId都错乱了

UPDATE demo.demo SET age=0, AutoId='', name='9999999', UserMongoId=33 WHERE age=0 AND AutoId='' AND name='123456' AND UserMongoId=33 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=1, AutoId='1', name='9999999', UserMongoId=11 WHERE age=1 AND AutoId='1' AND name='123456' AND UserMongoId=11 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=2, AutoId='666', name='9999999', UserMongoId=33 WHERE age=2 AND AutoId='666' AND name='123456' AND UserMongoId=33 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=33, AutoId='222', name='9999999', UserMongoId=0 WHERE age=33 AND AutoId='222' AND name='123456' AND UserMongoId=0 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=1000, AutoId='331', name='9999999', UserMongoId=56 WHERE age=1000 AND AutoId='331' AND name='123456' AND UserMongoId=56 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=1002, AutoId='1002', name='9999999', UserMongoId=22 WHERE age=1002 AND AutoId='1002' AND name='123456' AND UserMongoId=22 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05 UPDATE demo.demo SET age=6666, AutoId='66666666333', name='9999999', UserMongoId=99 WHERE age=6666 AND AutoId='66666666333' AND name='123456' AND UserMongoId=99 LIMIT 1; #start 18751 end 19272 time 2019-12-27 10:02:05

[1450793561]

[1450793561]

是不是mysql8版本的不支持

[13546215985]

+1

[13546215985]

我也遇到这个问题了，导出来的sql字段和值是错位的，没搞清楚啥原因，binlog2sql和依赖全都重装试了，一样的不行，出现问题的前两天还正常的

[miniminibox]

1). pymysql - 0.9.3 2).mysql-replication - 0.21 我之前也遇到这个问题,按照此版本装包即可解决

[13546215985]

十分感谢回复，后续关注

------------------ 原始邮件 ------------------ 发件人: "danfengcao/binlog2sql" @.>; 发送时间: 2022年8月1日(星期一) 下午3:07 @.>; @.@.>; 主题: Re: [danfengcao/binlog2sql] 解析出来的数据不对 (#64)

1). pymysql - 0.9.3 2).mysql-replication - 0.21 我之前也遇到这个问题,按照此版本装包即可解决

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.***>