DELETE
FROM
qx_site_weather_hour
WHERE
id IN (
SELECT
m.id
FROM
(
SELECT
id
FROM
qx_site_weather_hour A,
( SELECT site_id, date_time FROM qx_site_weather_hour GROUP BY site_id, date_time HAVING COUNT(site_id) > 1 ) B
WHERE
A.site_id = B.site_id
AND A.date_time = B.date_time
AND A.id NOT IN ( SELECT MIN( id ) AS ID FROM qx_site_weather_hour GROUP BY site_id, date_time HAVING COUNT(site_id) > 1 )) m
)
mysql删除重复数据
最新推荐文章于 2024-07-25 21:11:29 发布