sql语句
替换
1.批量替换数据库中指定的内容
merge into 目的表 a using 源表 b on (条件)
when matched then update set a.val=b.val
when not matched then insert (a.ID,a.clock,a.val) values (b.ID,b.clock,b.val);
sql语句
替换
1.批量替换数据库中指定的内容
merge into 目的表 a using 源表 b on (条件)
when matched then update set a.val=b.val
when not matched then insert (a.ID,a.clock,a.val) values (b.ID,b.clock,b.val);