删除表中重复数据

删除表中重复数据

 

//取出line_fancy2表中fancy_name相同的最小fancy_id 写进tmp表

CREATE TABLE tmp AS SELECT min( fancy_id ) AS col1
FROM line_fancy2
GROUP BY fancy_name;

 

//删除line_fancy2中fancy_id不在tmp表中的所有数据
DELETE FROM line_fancy2 WHERE fancy_id NOT IN (
SELECT col1
FROM tmp
);

 

//删除临时表

DROP TABLE tmp;