保留一条记录的比较麻烦..谁有更好的办法啊?
CREATE TEMPORARY TABLE newstemp1(id VARCHAR(10), title VARCHAR(250)) TYPE=HEAP;
insert into newstemp1(id,name) select max(b.id),b.title from phome_ecms_news a , phome_ecms_news b where a.title=b.title and a.id!=b.id group by b.title;
delete phome_ecms_news from phome_ecms_news a,newstemp1 b where a.title=b.title and a.id!=b.id;
|