zblog转移到帝国cms后文章标签与文章关联
清空表并且id从1开始
DELETE FROM phome_enewstagsdata;
ALTER TABLE phome_enewstagsdata AUTO_INCREMENT = 1;
然后执行
INSERT phome_enewstagsdata (tagid,classid,id,newstime) 
SELECT 
  B.tagid, A.classid, A.id, A.newstime
FROM phome_ecms_news A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagname,A.keyboard);
下面的是文章id=1的测试语句，测试是否正确，正确后再执行前面的语句。
DELETE FROM phome_enewstagsdata;
ALTER TABLE phome_enewstagsdata AUTO_INCREMENT = 1;
INSERT phome_enewstagsdata (tagid,classid,id,newstime) 
SELECT 
  B.tagid, A.classid, A.id, A.newstime
FROM phome_ecms_news A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagname,A.keyboard) where id=1;