mysql删除重复数据
DELETE FROM table WHERE id IN ( SELECT src.id FROM ( SELECT t1.id FROM table t1 WHERE ( t1.col1, t1.col2, t1.col3, t1.col4, t1.col5 ) IN ( SELECT col1, col2, col3, col4, col5 FROM table GROUP BY col1, col2, col3, col4, col5 HAVING count(*) > 1 ) AND t1.id NOT IN ( SELECT MAX(id) FROM table GROUP BY col1, col2, col3, col4, col5 HAVING count(*) > 1 ) ) src );