将新表导入为wp_posts_2
, 然后根据post\\u内容加入并删除所有重复项;然后合并这两个表。
以下SQL查询(未测试!)应给出要删除的新表中的帖子:
SELECT wp2.* FROM wp_posts_2 as wp2 LEFT JOIN wp_posts as wp ON wp2.post_content = wp.post_content WHERE wp2.post_content = wp.post_content
因此,您可以使用此查询删除条目(也未测试):
DELETE wp_posts_2.* LEFT JOIN wp_posts as wp ON wp_posts_2.post_content = wp.post_content WHERE wp_posts_2.post_content = wp.post_content
然后合并这两个表。