[摘要]+----+------+1 row in set (0.00 sec)把丢失的数据在slave上填补,然后跳过报错即可。mysql> insert into t1 values (2,BTV...
+----+------+
1 row in set (0.00 sec)
把丢失的数据在slave上填补,然后跳过报错即可。
mysql> insert into t1 values (2,'BTV');
Query OK, 1 row affected (0.00 sec)
mysql> select * from t1 where id=2;
+----+------+
关键词:详细说明在线上MYSQL同步报错故障处理办法代码总结