sql找出两张表中的不同

老板娘来碗面

于 2023-02-13 17:26:08 发布

阅读量1.6k

点赞数 1

分类专栏： sql 文章标签： mysql Powered by 金山文档

本文链接：https://blog.csdn.net/weixin_42279465/article/details/129012923

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

需求：

有两张相同结构的表，一个数据多，一个数据少，将两张表中不同的数据找出来并且插入到数据少的表里面

INSERT INTO "public"."waterqualmonitsection" ( "name", "info", "province", "longitude", "latitude", "river", "basin", "city", "status" ) 
SELECT
b.NAME AS NAME,
b.info AS info,
b.province AS province,
b.longitude AS longitude,
b.latitude AS latitude,
b.river AS river,
b.basin AS basin,
b.city AS city,
b.status AS status 
FROM
    waterqualmonitsectionnn b 
WHERE
    NOT EXISTS ( SELECT 1 FROM waterqualmonitsection A WHERE A.NAME = b.NAME AND A.province = b.province )