delete 去除重复数据

最新推荐文章于 2025-02-21 22:36:21 发布

自转的轮子

最新推荐文章于 2025-02-21 22:36:21 发布

阅读量2k

点赞数

分类专栏： java 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_27818157/article/details/79555496

版权

java 专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一种使用SQL进行数据校验的方法，通过检查重复记录并删除它们来确保数据的唯一性。具体操作包括从Fa_Stock_Plan_Detail表中删除具有相同plan_info_id和assets_info_id且distribute_state为'-1'的重复项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

具体业务，将一条数据加入时做校验，判断是否重复，重复删除

删选条件 plan_info_id相等，assets_info_id相等 distribute_state='-1'

DELETE m FROM `Fa_Stock_Plan_Detail` m
WHERE EXISTS (
SELECT sCode, nId FROM (
SELECT t.`plan_info_id` AS nId, t.`assets_info_id` AS sCode, COUNT(1) NUM 
FROM  `Fa_Stock_Plan_Detail` t WHERE 1=1 GROUP BY t.`plan_info_id`,t.`assets_info_id` HAVING NUM > 1 LIMIT 2000) tt
 WHERE tt.sCode = m.`assets_info_id` AND tt.nId = m.`plan_info_id` AND m.distribute_state='-1' AND plan_info_id='843')