svip

火车头数据库导入到数据库，帝国cms新闻 数据库发布模块sql语句

1. INSERT INTO phome_ecms_news (classid,title,newstime,username,userid,havehtml,newspath) VALUES ('30','[标签:标题]','[标签:时间]','作者','1','1','')
   
2. INSERT INTO phome_ecms_news_data_1 (id,classid,writer,befrom,newstext,dokey,newstempid) VALUES ('[文章编号:phome_ecms_news]','30','作者','来源','[标签:内容]','1','1')
   
3. INSERT INTO phome_ecms_news_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) VALUES('[文章编号:phome_ecms_news]','30','1','[标签:时间]','[标签:时间]','[标签:时间]','1')
   
4. update  phome_ecms_news set `filename`=`id` where id=[文章编号:phome_ecms_news]

复制代码