追加入库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('
',log_Content);
update zbp_post set log_Content=CONCAT(log_Content,'
');
update zbp_post set log_Content=(REPLACE(log_Content,'/r/n','
update zbp_post set log_Content=(REPLACE(log_Content,'
处理时间转换update zbp_post set log_PostTime=UNIX_TIMESTAMP(log_PostTime);