以下語句為將wordpress數(shù)據(jù)中文章id、發(fā)布時間、文章標題添加到帝國cms相關表

insert into phome_ecms_news(id,truetime,title) select ;id,sj,post_title from xingzuo_posts;

insert into phome_ecms_news_data_1(id,newstext) select ;id,post_content from xingzuo_posts;

update phome_ecms_news set newspath=FROM_UNIXTIME(truetime,'%Y/%m%d'),lastdotime=truetime,havehtml=1,groupid=0,newstime=truetime,filename=id;

update phome_ecms_news set `userid`=1,`username`='admin';

insert into phome_ecms_news_index(id,`classid`,`truetime`,`lastdotime`,`newstime`) select id,`classid`,`truetime`,`lastdotime`,`newstime` from phome_ecms_news;

update phome_ecms_news_index set `checked`=1,`havehtml`=1