April 7th, 2008

ecms 后台查询重复标题有几千个，怎样一次性删除

Category: Default, Author: humker, Popularity: 1%

在phpmyadmin中输入如下语句
DROP  TABLE  IF  EXISTS  newstemp1;
CREATE  TEMPORARY  TABLE
newstemp1(id  VARCHAR(10),title  VARCHAR(250))  TYPE=HEAP;
insert  into  newstemp1(id,title)  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  a  from  phome_ecms_news  a,newstemp1  b  where  a.title=b.title  and  a.id!=b.id;