批量删除WordPress重复文章的SQL语句命令

第一步：查找不重复文章的ID放进临时表my_tmp格内

CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title;

1	CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title;

第二步：导出不在my_tmp表格内的ID与标题，那就是重复

mysql -uroot -p fozhu920 -e "SELECT ID,post_title from wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp) INTO OUTFILE'/www/wwwroot/temp/title.txt'"

1	mysql -uroot -p fozhu920 -e "SELECT ID,post_title from wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp) INTO OUTFILE'/www/wwwroot/temp/title.txt'"

去除重复文章，只保留一篇

CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title;
DELETE FROM wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp);
DROP TABLE my_tmp;

CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title;

DELETE FROM wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp);

DROP TABLE my_tmp;

带区间

CREATE TABLE my_tmp2 AS SELECT MIN(ID) AS col2 FROM wp_posts where id > 623396 and id < 1301863 GROUP BY post_title;

1	CREATE TABLE my_tmp2 AS SELECT MIN(ID) AS col2 FROM wp_posts where id > 623396 and id < 1301863 GROUP BY post_title;