电脑技术学习

wordpress数据库转换帝国cms部分语句

dn001

以下语句为将wordpress数据中文章id、发布时间、文章标题添加到帝国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

标签: