利用sql命令删除标题重复的文章

全部的命令为下

create table my_tmp as select min(ID) as col1 from blog_posts group by post_title;

delete from blog_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 blog_posts group by post_title;delete from blog_posts where ID not in (select col1 from my_tmp); drop table my_tmp;

其中  blog_posts    是你的数据库中的那个一般为  wp_posts  的库