mysql中删除完全重复数据的准确SQL语句

删除数据库中重复的记录，只保留一条

DELETE FROM tb_gps_records WHERE id NOT IN (SELECT bid FROM (SELECT min(id) as bid FROM tb_gps_records GROUP BY busNo,longitude,latitude)as b);DELETE FROM tb_gps_records