mysql仅复制新记录到另一个

Question

我有 2 张 table :

语言温度:

sku|postid|fi|en|ru (15000 records / included 200 full_products records)

完整产品:

sku|postid|fi|en|ru|xx|zzz|aaaa|bbb (200 records)

postid 是唯一的，不能相同。

我只需将新记录从 lang temp 复制到 full_products。怎么可能查询？

Answer 1

尝试

INSERT INTO full_products (sku,postid,fi,en,ru)
SELECT sku,postid,fi,en,ru
  FROM lang_temp l
 WHERE NOT EXISTS 
 (
   SELECT 1 
     FROM full_products
    WHERE post_id = l.post_id
      AND sku = l.sku
 )