类似于ORACLE的merge。
语法: REPLACE INTO T1 SELECT *** FROM T2;
例子:
-- 测试代码
DROP TABLE IF EXISTS TEST.test1 ;
DROP TABLE IF EXISTS TEST.test2 ;
CREATE table TEST.test1
(a int
,b varchar(20)
,C varchar(20)
,UNIQUE KEY (a)
);
CREATE table TEST.test2
(a int
,b varchar(20)
,c varchar(20)
,UNIQUE KEY (a)
);
-- 插入测试数据
insert into TEST.test1 VALUES('1','aa','cc11');
insert into TEST.test1 VALUES('2','bb','c');
insert into TEST.test1 VALUES('3','cc','haha');
insert into TEST.test2 VALUES('1','aa','aa_111');
insert into TEST.test2 VALUES('2','111','222');
insert into TEST.test2 VALUES('4','aabb','hud');
insert into TEST.test2 VALUES('5','aacc','qwe');
结果:
test1:
test2:
用法:
-- 用法
REPLACE into TEST.test1 SELECT a,b,c FROM TEST.test2 ;
结果: