有表users
去重结果:
sql语句:
delete u1 FROM users AS u1
LEFT JOIN(
SELECT
*
FROM
users
GROUP BY `name`
HAVING
COUNT(`name`)>= 2
)AS u2 ON u1.`name` = u2.`name`
WHERE
u2.id < u1.id
如果在id无序的情况下可以将where 条件改为u2.id != u1.id