如有任何疑問和建議,歡迎加微信:fulipark探討。 承接WP建站以及其他互聯(lián)網(wǎng)方面的咨詢。 wordpress刪除重復(fù)文章一共有三種方法: 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; 3.php程序刪除 require('./wp-load.php'); $strsql="create table my_tmp as select min(ID) as col1 from cd_posts group by post_title"; $strsql1="delete from cd_posts where ID not in (select col1 from my_tmp)"; $strsql2="drop table my_tmp"; $result=mysql_query($strsql); $result=mysql_query($strsql1); $result=mysql_query($strsql2); 保存以上代碼以為delete.php,放在根目錄,想要刪除重復(fù)文章的時候,訪問這個文件就可以了 |
|