按照某个键值将最小ID创建新表储存:
create table tmp_table as select min(id) from wp_posts group by post_title;
然后将储存在tmp中的id与原表对照,将原表中不存在与tmp中的id删除:
delete from wp_posts where id not in (select * from tmp_table);
Default Category 我是只肥兔子 评论(0)
按照某个键值将最小ID创建新表储存:
create table tmp_table as select min(id) from wp_posts group by post_title;
然后将储存在tmp中的id与原表对照,将原表中不存在与tmp中的id删除:
delete from wp_posts where id not in (select * from tmp_table);