您应该能够执行相关的子查询来删除数据。查找所有重复的行，并删除除ID最小的行以外的所有行。对于MYSQL，需要使用内部联接（功能等同于EXISTS），如下所示：
delete games from games inner join (select min(id) minid, date, time, hometeam_id, awayteam_id, locationcity, locationstate from games group by date, time, hometeam_id, awayteam_id, locationcity, locationstate having count(1) > 1) as duplicates on (duplicates.date = games.date and duplicates.time = games.time and duplicates.hometeam_id = games.hometeam_id and duplicates.awayteam_id = games.awayteam_id and duplicates.locationcity = games.locationcity and duplicates.locationstate = games.locationstate and duplicates.minid <> games.id)
要进行测试，请替换
delete games from games为
select * from games。不要只在您的数据库上运行删除操作：-)
