1:首先转tag update phome_ecms_news_data_1 left join phome_ecms_news on phome_ecms_news_data_1.id = phome_ecms_news.id set phome_ecms_news_data_1.infotags = select keyboard from phome_ecms_news
2:insert into phome_enewstagsdata (tagid,classid,num) select id,tag,total from dede_tagindex
3:insert into phome_enewstagsdata (tagid,classid,id) select tid,typeid,aid from dede_taglist
|