561
581
insert into t1 values (1,1),(2,2);
562
582
insert into t2 values (1,1),(4,4);
565
585
UPDATE t2,t1 SET t2.a=t1.a+2;
567
587
select * from t2 /* must be (3,1), (4,4) */;
568
588
show master status /* there must be the UPDATE query event */;
574
594
insert into t1 values (1,2),(3,4),(4,4);
575
595
insert into t2 values (1,2),(3,4),(4,4);
578
598
UPDATE t2,t1 SET t2.a=t2.b where t2.a=t1.a;
579
599
show master status /* there must be the UPDATE query event */;
583
603
set @@session.binlog_format= @sav_binlog_format;