2679
2679
INSERT INTO replace_table values (1,1),(2,2);
2680
2680
CREATE TABLE update_table (a INT, b INT, PRIMARY KEY(a));
2681
2681
INSERT INTO update_table values (1,1),(2,2);
2682
2684
INSERT IGNORE INTO insert_table SELECT * FROM filler_table;
2684
2686
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.