Mysql 删除重复数据，保留id最小的

67snow

于 2021-01-14 13:38:33 发布

阅读量224

点赞数

分类专栏：后端文章标签： mysql

本文链接：https://blog.youkuaiyun.com/weixin_42167468/article/details/112604978

版权

后端专栏收录该内容

21 篇文章

订阅专栏

DELETE
FROM
	jeepin_xsa_gzh_msg
WHERE
	id IN (
		SELECT
			a.id
		FROM
			(
				SELECT
					id
				FROM
					jeepin_xsa_gzh_msg
				WHERE
					member_id IN (
						SELECT
							member_id
						FROM
							jeepin_xsa_gzh_msg
						GROUP BY
							member_id
						HAVING
							COUNT(1) > 1
					)
				AND id NOT IN (
					SELECT
						MIN(id)
					FROM
						jeepin_xsa_gzh_msg
					GROUP BY
						member_id
					HAVING
						COUNT(1) > 1
				)
			) a
	)