CREATE TABLE a (id int, value int);
INSERT INTO a (id) VALUES (1),(2),(3);
SET SQL_LOG_BIN=0;
CREATE TABLE b (id int, value int);
INSERT INTO b (id) VALUES (1),(2),(3);
SET SQL_LOG_BIN=1;
UPDATE a JOIN b ON a.id=b.id SET a.value=123;