DELETE
FROM
表
WHERE
FIND_IN_SET(
id,
(
SELECT
GROUP_CONCAT( id )
FROM
(
SELECT
GROUP_CONCAT( id ) id
FROM
表
GROUP BY
筛选的字段
) t
)
)
AND id NOT IN (
SELECT
f.id
FROM
(
SELECT
min( id ) id
FROM
表
GROUP BY
checkTime
) f
)
mysql 去除重复数据
于 2024-06-12 11:06:16 首次发布