DELETE
FROM
eds_conference
WHERE
conf_uri IN (
SELECT
conf_uri
FROM
(
SELECT
conf_uri
FROM
eds_conference
GROUP BY
conf_uri
HAVING
count(conf_uri) > 1
) a
)
AND id NOT IN (
SELECT
MIN(id)
FROM
(
SELECT
MIN(id) AS id
FROM
eds_conference
GROUP BY
conf_uri
HAVING
count(conf_uri) > 1
) b
);
mysql删除重复数据
最新推荐文章于 2024-08-28 08:50:29 发布