INSERT INTO e_question_catalog_num ( catalog_id ) SELECT catalog_id FROM e_question_catalog WHERE NOT EXISTS ( SELECT e_question_catalog_num.catalog_id FROM e_question_catalog_num WHERE e_question_catalog_num.catalog_id = e_question_catalog.catalog_id)
参考
INSERT INTO coupon_repository.ekp_repo_merchant(name,pic_url,external_id, external_shop_id,type,external_cid,external_category,external_level,brand,website_url,keywords,description) SELECT tb_nick,logo_img_url,user_id,sid,shop_type,shop_cate,category,level,brand,website_url, keywords,description FROM e_coupon.ec_merchant WHERE NOT EXISTS (SELECT * FROM coupon_repository.ekp_repo_merchantWHEREname = e_coupon.ec_merchant.tb_nick)
