ADO-MySQL-显示BINLOG事件

任何可以解释这一点的人,也许是另一种解决方案....

软件为W2019和MySQL 8.0.18 ...

当我在ASP Classic和ADO中运行此查询时

Result.Open "SHOW BINLOG EVENTS LIMIT 0,10",MySQLConn

Set Result = MySQLConn.Execute("SHOW BINLOG EVENTS LIMIT 0,10")

我得到这个结果:

Log_name        Pos     Event_type      Server_id       End_log_pos     Info     
W2019_SERVER-bin.000        4       Format_desc     1       124     Server ver: 8.0.18,W2019_SERVER-bin.000        124     Previous_gtids      1       155          
W2019_SERVER-bin.000        155     Anonymous_Gtid      1       234     SET @@SESSION.GTID_N     
W2019_SERVER-bin.000        234     Query       1       319     BEGIN    
W2019_SERVER-bin.000        319     Table_map       1       415     table_id: 101 (hmail     
W2019_SERVER-bin.000        415     Update_rows     1       769     table_id: 101 flags:     
W2019_SERVER-bin.000        769     Xid     1       800     COMMIT /* xid=43 */  
W2019_SERVER-bin.000        800     Anonymous_Gtid      1       879     SET @@SESSION.GTID_N     
W2019_SERVER-bin.000        879     Query       1       972     BEGIN    
W2019_SERVER-bin.000        972     Table_map       1       1068        table_id: 101 (hmail

预期是这样(来自phpMyAdmin):

Log_name    Pos     Event_type  Server_id   End_log_pos     Info    
W2019_SERVER-bin.000019     4   Format_desc     1   124     Server ver: 8.0.18,Binlog ver: 4
W2019_SERVER-bin.000019     124     Previous_gtids  1   155     
W2019_SERVER-bin.000019     155     Anonymous_Gtid  1   234     SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
W2019_SERVER-bin.000019     234     Query   1   319     BEGIN
W2019_SERVER-bin.000019     319     Table_map   1   415     table_id: 101 (hmail.hm_fetchaccounts)
W2019_SERVER-bin.000019     415     Update_rows     1   769     table_id: 101 flags: STMT_END_F
W2019_SERVER-bin.000019     769     Xid     1   800     COMMIT /* xid=43 */
W2019_SERVER-bin.000019     800     Anonymous_Gtid  1   879     SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
W2019_SERVER-bin.000019     879     Query   1   972     BEGIN
W2019_SERVER-bin.000019     972     Table_map   1   1068    table_id: 101 (hmail.hm_fetchaccounts)

似乎ADO在错误的位置(第一列和最后一列)剪切了我的记录集

有任何想法的人吗? :D

lvcha108 回答:ADO-MySQL-显示BINLOG事件

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/2549587.html

大家都在问