追加入库
insert into zbp_post (log_ID) select ID from wp_posts;
删除隐藏文章
delete from zbp_post where log_ID in (SELECT ID FROM wp_posts where post_status='inherit'); delete from zbp_post where log_Title="自动草稿";
分类去重
SELECT * FROM wp_terms GROUP BY ID;
处理文章
update zbp_post set log_Content=CONCAT('<p>',log_Content); update zbp_post set log_Content=CONCAT(log_Content,'<p>'); update zbp_post set log_Content=(REPLACE(log_Content,'/r/n','<p></p>')); update zbp_post set log_Content=(REPLACE(log_Content,'<p></p>',''));
处理时间转换
update zbp_post set log_PostTime=UNIX_TIMESTAMP(log_PostTime);