zblog网站数据迁移到帝国cms中网站关键词由{223} {224} {225} 替换成223,224,225

zblog网站数据迁移到帝国cms中网站关键词由{223} {224} {225} 替换成223,224,225
keyboard关键词替换sql语句
UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'}{',',');
UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'{','(');
UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'}',')');
查找keyboard为空的sql
SELECT * FROM phome_ecms_news where keyboard='';
增加一列作为空的样例tagid = 26269
INSERT INTO `moban_aiyiliu_com`.`phome_enewstags` (`tagid`, `tagname`, `num`, `isgood`, `cid`, `tagtitle`, `tagkey`, `tagdes`, `fclast`) VALUES (26269, '没有的事情', 1, 0, 0, '', '', '', 0);
keyboard为空的都替换为26269
UPDATE phome_ecms_news set keyboard=26269  where keyboard='';
替换完毕后执行如下命令，其中id=2是为了验证一下命令，线上正常执行去掉where id=2即可。
UPDATE phome_ecms_news set keyboard=(select GROUP_CONCAT( tagname SEPARATOR ',') as zuizhong   from phome_enewstags where 
FIND_IN_SET(tagid,keyboard)
) where id=2; 
单独执行1302,1303,7509,7510,7511,7512,3207,7513,4901,4349样例
单独执行sql
select GROUP_CONCAT( tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in 
(1302,1303,7509,7510,7511,7512,3207,7513,4901,4349)
如果执行中提示keyboard data too long  把字符串长度80修改为200，再执行即可。
执行完毕后把为空的样例替换为空
UPDATE phome_ecms_news set keyboard=''  where keyboard='没有的事情';
流程完毕。
下面的是安装东坡插件infotags执行的命令
第一步
 UPDATE phome_ecms_news_data_1 set infotags=REPLACE(infotags,'}{',',');
 UPDATE phome_ecms_news_data_1 set infotags=REPLACE(infotags,'{','');
 UPDATE phome_ecms_news_data_1 set infotags=REPLACE(infotags,'}','');
第二步
 UPDATE phome_ecms_news_data_1 set infotags=26269  where infotags ='';
第三步 
 UPDATE phome_ecms_news_data_1 set infotags=(select GROUP_CONCAT( tagname SEPARATOR ',') as zuizhong   from phome_enewstags where 
FIND_IN_SET(tagid,infotags)
)
 第四步
 UPDATE phome_ecms_news_data_1 set infotags=''  where infotags='没有的事情';
完毕
批量修改下载地址downpath的命令
UPDATE phome_ecms_news set downpath=CONCAT('游客下载::::::https://pan.baidu.com/::::::0::::::0::::::','扣点下载::::::',downpath,'::::::1::::::119::::::','会员下载::::::',downpath,'::::::2::::::0::::::') where id=1;
东坡tag插件修改tag地址为id命令
UPDATE phome_dp_tagsadd set py=tagid;