MySQL 去重SQL

最新推荐文章于 2024-09-20 23:28:04 发布

weixin_34067980

最新推荐文章于 2024-09-20 23:28:04 发布

阅读量497

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：https://juejin.im/post/5a26522951882546d71f31a5

DELETE
	t_trace_register
FROM
	t_trace_register,
	(
		SELECT
			min(id) AS id,
			user_id
		FROM
			t_trace_register
		GROUP BY
			user_id
		HAVING
			count(*) > 0
	) AS t2
WHERE
	t_trace_register.user_id = t2.user_id
AND t_trace_register.id > t2.id
复制代码