匹配有update,无insert
MERGE INTO vip_info A
USING(select cid, vip_level, create_time from vip_info_temp) B
ON (a.cid = b.cid)
WHEN MATCHED THEN
UPDATE
SET a.vip_level = b.vip_level,
a.create_time = b.create_time
WHEN NOT MATCHED THEN
INSERT (cid, vip_level, create_time)
VALUES (b.cid, b.vip_level, b.create_time);
commit;