mysql 删除表内重复字段，并保留ID最大的一个

DELETE 
FROM
 cube
WHERE
 uploadfile IN ( SELECT t.uploadfile FROM ( SELECT uploadfile FROM cube GROUP BY uploadfile HAVING COUNT( uploadfile ) > 1 ) t ) 
AND id not in (SELECT dt.maxid FROM (SELECT MAX(id) AS maxid FROM cube GROUP BY uploadfile HAVING COUNT( uploadfile ) > 1) dt)