734
CREATE TABLE t1 (f1 INT, f2 INT );
735
CREATE TABLE t2 (f1 INT PRIMARY KEY, f2 INT);
736
INSERT INTO t1 VALUES (1,1),(2,2),(10,10);
737
INSERT INTO t2 (f1, f2) SELECT f1, f2 FROM t1;
738
INSERT INTO t2 (f1, f2)
739
SELECT f1, f1 FROM t2 src WHERE f1 < 2
740
ON DUPLICATE KEY UPDATE f1 = 100 + src.f1;