分两段代码分别执行，第一段是删除多余重复标题，第二段是跟随内容删除多余的TAG标签，两个SQL命令需要分别执行。
DELETE
FROM
le_cms_article
WHERE
title IN ( SELECT a.title FROM ( SELECT title FROM le_cms_article GROUP BY title HAVING count( title ) > 1 ) a )
AND id NOT IN (
SELECT
b.id
FROM
( SELECT id FROM le_cms_article GROUP BY title HAVING count( title ) > 1 ) b
)delete from le_cms_article_data where not exists (select * from le_cms_article where le_cms_article_data.id =le_cms_article.id);
帝国CMS模板网(www.daixiao360.com)长期承接源码模板定制、帝国CMS仿站、插件二次开发、采集规则与网站维护。
微信
QQ
QQ交流群
