Insert intophone _ enews class (bclassid, bclassified, classname, myorder, classpath, intro, classpagekey) select id, reid, typename, sortrank, typedir, description, keywords from dede_arctype.

Second, imported goods

Insert phome_ecms_news (id, classid, truetime, onclick, title, titlepic, filename, newstime, lastdotime, smalltext, keyboard) select id, typeid, sortrank, click, title, Litpic, filename, pubdate, senddate, description, keywords come from dede_archives.

Third, import the article source author

Update dede_archives` da, phome _ ecms _ news _ data _1mensetda.source = men.be from, da.writer=men.writer where da.id=men.id

Fourth, import the text (content) of the article

insert into phome _ ecms _ news _ data _ 1(id，classid，newstext) select aid，typeid，body from dede_addonarticle men

If the beginning of your dede data table is something else, the dede_ in the code should also be changed to the beginning of your dede database.