73
88
INSERT t2 VALUES (5,6,30,1), (7,4,40,1), (8,9,60,1);
74
89
INSERT t2 VALUES (2,1,11,2), (7,4,40,2);
75
90
INSERT t1 SELECT a,b,c FROM t2 WHERE d=1 ON DUPLICATE KEY UPDATE c=t1.c+100;
77
93
INSERT t1 SET a=5 ON DUPLICATE KEY UPDATE b=0;
80
97
INSERT t1 SELECT a,b,c FROM t2 WHERE d=2 ON DUPLICATE KEY UPDATE c=c+VALUES(a);
81
98
INSERT t1 SELECT a,b,c FROM t2 WHERE d=2 ON DUPLICATE KEY UPDATE c=t1.c+VALUES(t1.a);
82
100
SELECT *, VALUES(a) FROM t1;