wordpress数据库转换帝国cms部分语句_惠州计算机wordpress培训

以下语句为将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

标签：惠州计算机软件培训惠州计算件软件开发惠州计算机软件基础惠州计算机MySQL培训