MYSQL 中把某个表里的记录复制到另一个数据库的表中，重复的不插入

Chery Qi

于 2022-07-19 18:07:20 发布

阅读量542

点赞数

分类专栏： Mysql 文章标签：数据库 sql

本文链接：https://blog.youkuaiyun.com/cheryjava/article/details/125877854

版权

Mysql 专栏收录该内容

6 篇文章

订阅专栏

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_merchant` WHERE `name` = e_coupon.`ec_merchant`.`tb_nick`)