DELETE
FROM
`user`
WHERE
`name` IN (
SELECT
`name`
FROM
(
SELECT
`name`
FROM
`user`
GROUP BY
`name`
HAVING
count(`name`) > 1
) AS user1
)
AND id NOT IN (
SELECT
id
FROM
(
SELECT
MAX(id) AS id
FROM
`user`
GROUP BY
`name`
HAVING
count(`name`) > 1
) AS user2
)
mysql 常用查询操作
最新推荐文章于 2021-02-02 01:27:18 发布