帝国cms文章标签与文章关联的sql命令

SELECT 
    A.id, A.keyid typeIds, GROUP_CONCAT(B.`tagname`) AS typeNames
FROM phome_ecms_news_data_1 A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagid,A.keyid)
GROUP BY A.id

INSERT phome_enewstagsdata (tid,tagid,classid,id) 
SELECT 
   B.tagid, A.id, A.classid
FROM phome_ecms_news_data_1 A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagid,A.keyid)

INSERT phome_enewstagsdata (tagid,classid,id) 
SELECT 
  B.tagid, A.classid, A.id
FROM phome_ecms_news_data_1 A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagid,A.keyid) where id=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;
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);
测试用例
//重置表并且自增字段从1开始
DELETE FROM phome_enewstagsdata;
ALTER TABLE phome_enewstagsdata AUTO_INCREMENT = 1;
//测试文章id=1的标签数据插入到phome_enewstagsdata表中
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;