DELETE year, month, day, time, temp, count() FROM Weather GROUP BY year, month, day, time, temp having COUNT() >1;

Asked Aug 04 '17 at 18:50

Active Aug 04 '17 at 22:22

Viewed 16 times

I need help changing syntax to delete duplicates in my data. I have tried the following query:

DELETE year, month, day, time, temp, COUNT(*)
FROM Weather
GROUP BY year, month, day, time, temp
HAVING COUNT(*) > 1;

edited Aug 04 '17 at 22:22

Fruchtzwerg

asked Aug 04 '17 at 18:50

Chelsea Gould

Possible duplicate of [Remove duplicate rows in MySQL](https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql) – Jonathan Aug 04 '17 at 19:28
Can you show the full create table statement for `Weather`? – Riedsio Aug 10 '17 at 16:35

DELETE year, month, day, time, temp, count(*) FROM Weather GROUP BY year, month, day, time, temp having COUNT(*) >1;