46
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and the slave.
45
47
INSERT INTO t2 (field_a, field_b, field_c) VALUES (6, 'f', '6f');
46
48
INSERT INTO t1 (field_1, field_2, field_3)
47
49
SELECT t2.field_a, t2.field_b, t2.field_c
54
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and the slave.
52
56
id field_1 field_2 field_3