Apr
7
ecms 后台查询重复标题有几千个，怎样一次性删除
Filed Under Default
在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;
Comments
Leave a Reply
